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: which instance will be connect to without specify net service name?

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

From: Alex Ivascu <alex_at_ivascu.comNOSPAM>
Date: Sun, 11 Aug 2002 07:32:01 GMT
Message-ID: <Rpo59.72188$sA3.18073@rwcrnsc52.ops.asp.att.net>


Same thing in NT. Set a global/temporary env. variable with set ORACLE_SID=yoursid

Alex Ivascu

"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
>
>
Received on Sun Aug 11 2002 - 02:32:01 CDT

Original text of this message

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