Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8 question #2
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 11/6/00, 10:34:44 PM, jkyao_at_my-deja.com wrote regarding Re: Oracle8 question #2:
> If I set the ORALE SID=MYOTHERDB, will instance MYDB stopped?
> where should change the ORACLE SID? In inital parameter file?
> After I open to instances, how can I switch between those two??
> JK
The already running instance will not be stopped.
It's an OS specific environmental variable. In Unix you would:
export ORACLE SID=MYOTHERDB
At the SQL> prompt:
CONNECT <userid>/<password>@MYOTHERDB
or
CONNECT <userid>/<password>@MYDB Received on Mon Nov 06 2000 - 23:17:01 CST