Re: which instance will be connect to without specify net service name?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 11 Aug 2002 11:43:28 -0700
Message-ID: <92eeeff0.0208111043.36591cea@posting.google.com>

"PanTao" <pantao_fz_at_21cn.com> wrote in message news:<aj4tii$1j5b$1_at_mail.cn99.com>...
> Hi, all
>
> On a winNT + oracle enviroment, I install two instance. So
> if I use sqlplus to login locally, such as
> splplus /nolog
> connect / as sysdba,
>
> which instance will I connect to? What specify the default
> instance?
>
> For unix enviroment, I think the ORACLE_SID enviroment specify
> the instance. Is it so?
>
> Thanks,
> PanTao

Primarily, there is no difference how Oracle tools work on Unix or Win32. You have ORACLE_SID variables in both environments which tells sqlplus or server manager which instance to connect to.

On Unix you do, $ ORACLE_SID=YourSid export ORACLE_SID On Windows you do, C:\> set ORACLE_SID=YourSid

before you launch sqlplus or server manager.

HTH
//Rauf Sarwar Received on Sun Aug 11 2002 - 13:43:28 CDT