Re: Environment Variables on NT

Slight correction:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment]
is where the active session's path resides.

TNSless connection test:

cmd
set ORACLE_SID=<sidname>
sqlplus /nolog
connect username/pass

Alternate:
check SQLNET.ORA for the following entry and add if not there. SQLNET.AUTHENTICATION_SERVICES= (NTS) Open Local Machines User Manager and add yourself to the ORA_DBA group. Right-Click My Computer>Manage>Local Users and Groups>Groups>ORA_DBA Make sure you or the group you are in is in this group then,

cmd
SET ORACLE_SID=<sidname>
Connect / as sysdba

This should work if all is installed correctly and not running 9i and 10g on same box.

ORACLE_SID can be set as an environment variable or it can be created or set in the Oracle Registry Key associated with the current home.

To make sure, always set at the cmd prompt prior to launching sqlplus using set ORACLE_SID= just as you'd export in unix/linux.

Hope this helps

EscVector wrote:
> Path is loaded at session logon (interactive or batch) from the
> following:
>
> [HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session
> Manager\Environment\Path]
>
> This setting is modifiable in the registry, but only takes effect after
> logoff/logon.
> The Environment Applet calls Winapi to set this dynamically w/o reboot,
> so it's the best place to alter.
>
> What is the exact connection error.
>
>
> Robbert van der Hoorn wrote:
> > "mike" <hillmw_at_charter.net> schreef in bericht
> > news:1162570461.290106.74580_at_b28g2000cwb.googlegroups.com...
> > > Charles,
> > >
> > > I didnt see any of them so I have to regedit.
> > >
> > > Mike
> > >
> > > Charles Hooper wrote:
> > >> mike wrote:
> > >> > 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.
> > >>
> > >> 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.
> > >
> >
> > Create them using the system control panel. Path is NOT a registry variable
> > (although deep down somewhere it might be)
Received on Fri Nov 03 2006 - 12:28:22 CST