Connect remote to multiple instances

From: Foggy <sjefke12_at_hotmail.com>
Date: 23 Apr 2002 07:03:13 -0700
Message-ID: <f78e018a.0204230603.4fe32c6e@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 - 09:03:13 CDT