-
Hi,
I've created a database link for a remote db.
whenever I tried to connect from my local db to the remote
one using my link, it gives me this error..
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
OR
ERROR at line 1:
ORA-02019: connection description for remote database not found ( when I append .WORLD to the service name)
I am able to connect DIRECTLY to the remote db from my
sql plus ( connect remId/remPass@remService_name ) without problem !!!
ANY IDEA!!!!!
-
1. Check the TNSNAMES.ORA file on the server you are trying to connect from to make sure it has the entry.
2. create the db_link with the explicit sql*net string from the TNSNAMES.ORA file. ( create database link link1 using '(DESC=(...))'
-
Also make sure that the global_name in the init.ora file is set to false . It creates a problem in case you are trying to link to a database with the same SID name
regadrs
