Database Link Problem

From: Rajesh M <raju_m_at_hotmail.com>
Date: Tue, 17 Nov 1998 17:17:04 +0100
Message-ID: <3651a19e.0@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 Tue Nov 17 1998 - 10:17:04 CST