Re: ORA-12154 when using DB Link
Date: 17 Oct 2002 00:33:30 -0700
Message-ID: <a20d28ee.0210162333.4eb939e3_at_posting.google.com>
bcratan <member_at_dbforums.com> wrote in message news:<1935651.1034789304_at_dbforums.com>...
> Hi,
>
> I have a tnsnames entry "MISDW" for a database on a remote server.
> I can log on to this database using the connect string "MISDW"
> I have created a Database link named BIDW from one database to this
> remote database using "MISDW". But when I try to run a select
> statement like :
> SQL>select count(*) from table_1_at_BIDW
>
> I get the error :
> SQL>select count(*) from table_1_at_BIDW
> *
> ERROR at line 1:
> ORA-12154: TNS:could not resolve service name
>
> Where am I going wrong ?
>
> TIA
> Ratan
The entry needs to exist in the tnsnames.ora on the *database server* as links are handled by the server only. Please check and correct your server's tnsnames.ora
Hth
Sybrand Bakker
Senior Oracle DBA
Received on Thu Oct 17 2002 - 09:33:30 CEST