Re: Database Link::ORA-12154: TNS:could not resolve........

From: <frank.van.bortel_at_gmail.com>
Date: 17 Nov 2006 03:19:56 -0800
Message-ID: <1163762396.663458.8810@m7g2000cwm.googlegroups.com>

sanjeev schreef:

> Hi Freinds,
>
> My platform is windows 2000 and oracle 9.2.0.....
>
> I have created link as below :
>
> create public database link A_LINK
> connect to SCOTT identified by tiger
> using 'AVAYA'
> --------------------------------
> In tnsnames.ora file
>
> AVAYA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ADB)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = AVAYA.ADB)
> )
> )
> -------------------------------
> select *
> from BOSSDEPARTMENT_at_A_LINK;
>
> After firing the above query i got the error
>
> ERROR at line 2:
> ORA-12154: TNS:could not resolve service name

Is the a default domain in sqlnet.ora? If so - use that in the db link definition.
Is this the tnsnames from the server?

Also: is global_names true? If so, you will get another error if avaya point
to a sid orcl (or anything different than avaya - however, not the error
you are facing) Received on Fri Nov 17 2006 - 05:19:56 CST