Home » RDBMS Server » Networking and Gateways » accessing remote database has same name as local one
accessing remote database has same name as local one [message #66428] Fri, 07 June 2002 08:32 Go to next message
algui
Messages: 1
Registered: June 2002
Junior Member
On the "client machine" there is a local database that has exactly the same name as the other one on the remote server i'm trying to connect to.
It always ends up connecting to the local one even if the tnsnames.ora is configured for the remote one. Is there a way to get the ORACLE_SID to point to the other server.
Re: accessing remote database has same name as local one [message #66430 is a reply to message #66428] Fri, 07 June 2002 10:59 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The following are sample entries of tnsnames.ora file.

here there are two databases, both named high9i. one is remote and one is local

configure the connect string as different.
eg:
for remote database= high9i
for localdatabase  = local

HIGH9I =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.27)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = high9i)
    )
  )

LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = high9i)
    )
  )

SQL> connect scott/tiger@high9i
Connected.
SQL> connect scott/tiger@local
Connected.
SQL> 

Previous Topic: oracle error
Next Topic: Plz Help me for Connecting card Sweeping Machine With Oracle 8.0.5
Goto Forum:
  


Current Time: Wed Feb 28 14:28:59 CST 2024