You can also switch between SIDs at a DOS prompt by specifying SET
ORACLE_SID=sid. This is handy when you need to use SVRMGR23 or another
command line utility.
--
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)
Sanlam <joe_at_soap.com> wrote in article
<01bccda2$824be820$b6040a0a_at_com00331>...
> 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
