Path is loaded at session logon (interactive or batch) from the
following:

[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Se ssion
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:

Slight correction:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Contro l\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:

"EscVector" <analyze (AT) webthere (DOT) com> schreef in bericht
news:1162577652.595103.303770 (AT) f16g2000cwb (DOT) googlegroups.com...
Yep. But that's NOT where to SET it!!!!!!!

"Path is NOT a registry variable
(although deep down somewhere it might be) "

I was just showing that Path is a registry "variable" and you can set
it in CurrentControlSet, you just have to log out and log in if you
choose to set it this way.




Robbert van der Hoorn wrote:

I made the env setting changes, but then I got an error message when
the box came up talking about problems saying to see the "event
viewer".

I've never seen that before. Any idea where that is?

Mike

EscVector wrote:

mike wrote:
That error message may be related to the environment variables that you
created. If one of the environment variables is over-riding a setting
that is in the registry, one of the Oracle related services may fail to
start. This can also be a result of creating or editing the entries in
the registry to invalid or conflicting values. Check to see which
Oracle related services are started. Also check the alert logs for
information.

Note: the error message that you are reporting is very generic. You
may see the same error message if you were using a serial mouse on NT
and decide instead to use a PS/2 mouse. The Windows event viewer will
give you a better idea of the actual error.

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

Is this a production box?
What is the OS version and path level?
What was posted to the event viewer? Any good error or just junk.

Do you have only one oracle version/home installed? Settings get
tricky when multi-homed with 9i and 10g versions. Grid and OEM don't
play well together.

If you got the error when modifying the path via the windows applet,
there is something outside Oracle wrong with the machine.

Easy enough to fix Oracle, if it's a windows error, that can be more
annoying.





mike wrote:

mike wrote:
Right click on My Computer and select Manage. The Computer Management
aplet will open. Expand the System Tools branch, then expand Event
Viewer. Any messages from Oracle will be viewable by selecting the
Application category.

HTH

-g