Home » RDBMS Server » Networking and Gateways » DB link problem
DB link problem [message #66966] Mon, 28 April 2003 06:18 Go to next message
D subbarao
Messages: 1
Registered: April 2003
Junior Member
Dear sir,

Can any one help me out in the oracle database link

I am using Unix oracle database which has two users one is for financials and another one for business operations.

I get error message "TNS:could not resolve service name" when i am trying to access the tables through db link from my operation user to financials users.

Cany anyone tell us would could be the problem
Re: DB link problem [message #66968 is a reply to message #66966] Tue, 29 April 2003 05:28 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
your entries in tnsnames.ora are not correct.
first create proper entries and try to establish a sqlplus connection.
later, create the dblink
Previous Topic: ORA-12158
Next Topic: Connect without TNSNames entry
Goto Forum:
  


Current Time: Thu Nov 28 05:14:19 CST 2024