Re: Database Link Problem

Rajesh,

     Does the database server's TNS_NAMES.ORA have the name as well? Under the same name, db2?

Jay!!!

Rajesh M wrote:

> 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 Tue Nov 17 1998 - 11:55:41 CST