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: sqlplus /sqlnet question

Re: sqlplus /sqlnet question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 06 Feb 1999 07:28:31 +0100
Message-ID: <36BBE10F.4510F2E1@sybrandb.demon.nl>


Yep,

the 2: is an abbreviation/shortcut for the two task driver. This feature has always been there. Obviously, it works on the server only.

Hth,
Sybrand Bakker, Oracle DBA

joe gulla wrote:

> I have ntserver with 2 instances say aa and bb. the tnsnames and
> listener files
> are working correctly and I can connect to both via sqlnet alias but
> here is my question.
> when I am on local the machine I can access either instance via
> sqlnet alias or
> at the dos prompt I can set oracle_sid=instance name access is fine
> works fine.
> when using gui's I found out by accident that using 2:instance name
> as
> the service works ,eliminating using my alias . ex
> system/manager_at_2:aa
> does anyone know where the hell the 2 comes from
> Joe g.


Received on Sat Feb 06 1999 - 00:28:31 CST

Original text of this message

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