Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8 question #2

Re: Oracle8 question #2

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Tue, 07 Nov 2000 05:17:01 GMT
Message-ID: <20001107.5170100@mis.configured.host>

>>>>>>>>>>>>>>>>>> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US