-
hi
i create db_link ...(db_link created)
i use SELECT * FROM DEPT@db_link_name;
gives me error TNS:COULD NOT RESOLVE SERVICE NAME
i try to connect to remote db using ...
CONNECT USER/PWD@DB_NAME2 and i get connected
pls help me to fix this step by step please.....
what should i have on my tnsname.ora?example pls..
thank for help....
-
Post steps you have followed for creating dblink with syntax.
-
When using a dblink, the definition must also exists in TNSNAME.ORA at the serverside.
-
when creating a DB*Link, the syntax should be :
create database link mylink
connect to user
identified by pwd
using 'connect_string';
and this connect string must be in your tnsnames.ora, if not you get the famous 12154 error ...
-
See the following thread and refer for my posting to see the syntax of create dblink.
http://www.dbasupport.com/forums/sho...?threadid=6584
-
Hi,
In init.ora file change global_names=false and source server and configure you tnsnames.ora to connect to the destination server.
Regards,
yajman