Re: Quiick 9i sqlplus shutdown question

"Randy Harris" <randy_at_SpamFree.com> wrote:

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

OK, how about LOCAL?

If not, but if only one instance is 'known' to Windows ( in the registry) , the OS authentication process will also contain info about which instance to authenticate to, hence, which instance to shutdown ( I think). Received on Tue Mar 23 2004 - 09:31:30 CST