Re: ORACLE_SID variable on NT 4.0

At the command line to set oracle_sid
c:\> set ORACLE_SID=test

to view what oracle_sid is currently set

either

c:\> set | more
or
c:\> echo %ORACLE_SID%

If you are using GUI tools the oracle_sid that will be used is the one defined in the registry,
look at local_machine->software->oracle, look for an entry ORACLE_SID.

Haresh Assumal wrote:

> I have created a new database on a new Instance (SID). I am running
> Oracle
> 8 on NT 4.0. When some of the utilties like sqlplus is run, how does
> it
> know what SID to run? I was told that there is a system variable
> called
> ORACLE_SID and if I want to run a ultility on another instance I set
> this
> variable before running the utlitity. However, I cannot see any system
>
> varaibale defined on my machine ORACLE_SID, what do I need to do? If
> there
> is not ORACLE_SID defined what does oracle default to?
> Thanks,
> Haresh
> E-mail: assumal_at_sprynet.com
Received on Tue Sep 30 1997 - 00:00:00 CDT