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.
Ben de Boer
when creating a DB*Link, the syntax should be :
create database link mylink
connect to user
identified by pwd
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.
In init.ora file change global_names=false and source server and configure you tnsnames.ora to connect to the destination server.
Click Here to Expand Forum to Full Width