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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Quiick 9i sqlplus shutdown question

Re: Quiick 9i sqlplus shutdown question

From: Randy Harris <randy_at_SpamFree.com>
Date: Tue, 23 Mar 2004 13:14:30 GMT
Message-ID: <WKW7c.15099$t16.8551425@newssvr28.news.prodigy.com>

"AnaCDent" <anacedent_at_hotmail.com> wrote in message news:dJM7c.37424$Bg.29655_at_fed1read03...
> Randy Harris wrote:
> > If I start sqlplus in 9i on windows and have NOT set an ORACLE_SID env
var
> > beforehand, then enter:
> >
> > SQL> connect / as sysdba
> > Connected
> > SQL> shutdown
> >
> > How does Oracle determine which instance to shut down? Or, I guess the
> > better question is, how does it determine which to connect to if I don't
> > tell it?
>
> Are you really 100% positive that ORACLE_SID is not set?
>
> What about TWO_TASK?

Yes. Neither variable is set. Received on Tue Mar 23 2004 - 07:14:30 CST

Original text of this message

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