You must check TNSNAMES on the server, as the database link is used by the
process on the server, not by you on your PC
Regards
Kurt Laugesen
Rajesh M wrote in message <3651a19e.0_at_news.euroconnect.dk>...
>Hi,
>create database link dblink
>connect to uid
>identified by pwd
>using 'db2';
>
>created database link.
>
>But, when I use the '@dblink' in my select I get TNS-could not resolve
>service name. However, I am able to connect to the other database using
>SQLPlus.
>
>I have checked my TNS_NAMES.ORA File and the entry for 'db2.world' exists
>and checked the same with TNSPING. I have checked my registry, oracle.ini
>for TNS_ADMIN parameter also. They seem to be right.
>
>oracle version 7.3.4.2
>
>Could some one help.
>
>Rajesh
>
>
Received on Wed Nov 18 1998 - 09:56:42 CST
