ORA-12154 when using DB Link

From: bcratan <member_at_dbforums.com>
Date: Wed, 16 Oct 2002 17:28:24 +0000
Message-ID: <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

--
Posted via http://dbforums.com

Received on Wed Oct 16 2002 - 19:28:24 CEST

This message: [ Message body ]
Next message: Ole Hansen: "OCI: Array Interface - multiple inserts"
Previous message: David Levine: "Re: Suse Linux Oracle Server - Partitioning"
Next in thread: Sybrand Bakker: "Re: ORA-12154 when using DB Link"
Reply: SEJ: "Re: ORA-12154 when using DB Link"
Reply: Sybrand Bakker: "Re: ORA-12154 when using DB Link"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message