I was trouble connecting to my Oracle database and they asked me to
check the environmentatl variables.

On an NT machine are these settings in the registry?

I'm looking to check some like:
dbms_type=ora
PATH=<oracle_home>\bin;... (<oracle_home>\bin in first position)
dbs_ora_tnsname=<sid>

Any help is appreciated.

mike wrote:
Right click on My Computer and choose Properties. An the Advanced tab is
a button for Environment Variables.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

mike wrote:
To check the environment variables:
1. From the Start Menu, select Run..
2. Type CMD and press the Enter key
3. Type SET and press the Enter key

Many of the Oracle related environment variables are stored in the
registry on Windows systems. Take a look in this location (and sub
folders):
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

To permanently change the environment variable, use the System Control
Panel. Any changes to the environment variables in a command prompt
window are valid only for that command prompt window. A reboot may be
necessary for changes to take effect.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

Charles,

I didnt see any of them so I have to regedit.

Mike

Charles Hooper wrote:

mike wrote:
To check your environment variables, either do what Charles suggested
from a command prompt or try:

Right-click on My Computer and select Properties. When the System
Properties box pops up, click the Advanced tab, then click the
Environment Variables button towards the bottom of the dialogue.

Environment variables have nothing to do with the registry.

HTH

-g

I am seeing some values like ORACLE_HOME set to
F:\oracle\product\10.2.0\client_1

in the key: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10 g_home1

so why are they not getting exposed in the environment?

Mike

mike wrote:

"mike" <hillmw (AT) charter (DOT) net> schreef in bericht
news:1162570461.290106.74580 (AT) b28g2000cwb (DOT) googlegroups.com...
Create them using the system control panel. Path is NOT a registry variable
(although deep down somewhere it might be)

So i am seeing user variable and system variables.

I put them in the user section?

Mike
gazzag wrote:

mike wrote:
Put the entries in the System variables section.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

mike wrote:
Oracle on Windows tries to be Windows friendly with the way certain
configuration settings are maintained. While on Unix platforms the
various settings are exported to environment variables, Oracle stores
those same settings in the Windows registry. Some of the environment
variables that are seen by issuing a SET command at a command prompt
are stored in various locations of the registry, while others may be
generated on the fly at Windows start up, or from various configuration
files that are read. Windows ultimately determines which environment
variables are automatically generated from the registry, and the Oracle
settings are not in that set of registry entries.

It may be possible to over-ride an Oracle related value stored in the
registry with a SET command in a batch file, or by specifying an entry
in the System Control Panel - as I recall, this is not recommended.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.