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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 11 Aug 2002 09:32:54 +0200
Message-ID: <ulc68ms4f0cd91@corp.supernews.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
>
>

likewise in NT
You have the registry var hklm\software\oracle\oracle_sid which is by default set to the last instance started. In a DOS box you need to
set ORACLE_SID

If you want a 'fixed' default connection you can set hklm\software\oracle\local to the service_name in tnsnames.ora of your default instance.

This is all documented of course.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sun Aug 11 2002 - 02:32:54 CDT