Re: Connect remote to multiple instances

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Tue, 23 Apr 2002 15:07:21 GMT
Message-ID: <JMex8.793$7X1.270222474@newssvr13.news.prodigy.com>

Johan,

You are right in your guess. There is such syntax in SQL*Plus - 'sqlplus username/pwd_at_server.sid'

Edit your client tnsnames.ora file (%ORACLE_HOME%\network\admin) to include two entries for DB1 and DB2:
DB1=

(DESCRIPTION =

       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.domain.com)(PORT =

1521))

   )
  (CONNECT_DATA = (SID = DB1)
  )
)

DB2=

(DESCRIPTION =

       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.domain.com)(PORT =

1521))

   )
  (CONNECT_DATA = (SID = DB2)
  )
)

Then connect with the @DB1 or @DB2 to the remote servers.

Check the latest Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"Foggy" <sjefke12_at_hotmail.com> wrote in message news:f78e018a.0204230603.4fe32c6e_at_posting.google.com...

> Hello,
>
> I have a NT box with 2 Oracle 8.0.5 instances, DB1 and DB2. Locally I
> can connect to both instances by setting ORACLE_SID to the SID that I
> want to connect to. Remotely, I can only connect to DB1, even if I set
> ORACLE_SID to DB2 (set on client). When I set ORACLE_SID to DB2 on the
> client, and I connect sqlplus user/pwd, I still get connected to DB1.
> How can I connect to instance DB2 from a remote client? I have
> searched the Google archive, but i could not find an answer. Is there
> something like 'sqlplus username/pwd_at_server.sid'?
>
> Thanks in advance.
>
> Johan

Received on Tue Apr 23 2002 - 10:07:21 CDT