Re: ORACLE_SID variable on NT 4.0

Hi

If you go to settings/control panel on the machine where your database is running and choose SYSTEM/ENVIROMENT you will be able to add a variable ORACLE_SID. As far as I know ORACLE will default to this when no connect string is supplied.

Cheers
akader_at_health.sanlam.co.za

Haresh Assumal <assumal_at_sprynet.com> wrote in article <01bccd22$815450e0$fab1aacc_at_mycomp.intermediainc.com>...
> 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