database link???

[ocpdude]

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!!!!!

[marist89]

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=(...))'

[puneet]

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