Re: ORA-12154 when using DB Link

Hi

Which version of Oracle do you have ?
I've read ther should be a problem when you are using sqlnet.authentication=(NTS) in sqlnet.ora, uncomment the line i you can and try again.

Svend

"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
>
> --
> Posted via http://dbforums.com
Received on Thu Oct 17 2002 - 08:49:13 CEST