All of the nodes in a RAC should have the same tnsnames.ora entry,
let us say you have 2 node oracle cluster, login to each node and
issue tnsping for the SID name that you want to check, i.e., tnsping
myprd1 the result should come out as OK, once this check is performed
you are all set to create the dblink:-

CREATE PUBLIC DATABASE LINK myprddblink
CONNECT TO devuser IDENTIFIED BY devpwd
USING myprd1;

Select count(*) from table@myprddblink;

If for some reason you get the famous tns names error then
make sure you have the SID name configured correctly in the
tnsnames.ora file.

Comments are closed.