To find the default SID - use regedit and look under
hkey_local_machine\software\oracle. There is a string value called
ORACLE_SID. This is where you need to change it. Oracle calls it a
system variable in all the setup instructions, but setting it in the
Control Panel will not work - you have to use the registry.
--
Tom Mettling
WT Chen & Company, Inc.
mettlingt_at_wtchen.com
Billy Verreynne wrote:
> 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?
>
> The default is ORCL I think. To set the SID, goto to Control Panel,
> click
> on the System applet and select the Environment Settings tab. In there
> you
> can create new variables, or change existing ones.
>
> regards,
> Billy
Received on Wed Oct 01 1997 - 00:00:00 CDT
