Link Databases and TNS error

From: Gordon C <gordonchapman_at_hotmail.comNOSPAM888>
Date: Tue, 23 Apr 2002 10:48:22 +0100
Message-ID: <TFe*5Tump@relay.lsl.co.uk>

I have 2 Databases DB1 and DB2

In DB1 I've ran

create public database link db2_link connect to user identified by pwd using 'db2';

The way that I undestand link databases to work is I should now be able to run

select * from tablename_at_db2_link, but I always get

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

TNSNAMES on both machines has an entry

DB2_LINK =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = DB2)
    )
  )

What am I doing wrong??

Thanks

GC Received on Tue Apr 23 2002 - 04:48:22 CDT