Re: Link Databases and TNS error

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 24 Apr 2002 07:05:05 +1000
Message-ID: <aa4ic1$ech$1@lust.ihug.co.nz>

Your tnsnames has an entry for "db2_link". Your link has been told to connect "using db2". Therefore, what the link is using is not what the tnsnames can resolve.

Remove the "_LINK" from the tnsnames.ora, and all will be well.

Regards
HJR "Gordon C" <gordonchapman_at_hotmail.comNOSPAM888> wrote in message news:TFe*5Tump_at_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 - 16:05:05 CDT