DB link problem [message #66966] |
Mon, 28 April 2003 06:18 |
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 |
|
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
|
|
|