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

From: sanjeev <sanjeev_atvankar_at_yahoo.co.in>
Date: 16 Nov 2006 23:36:08 -0800
Message-ID: <1163748967.973456.178970@e3g2000cwe.googlegroups.com>

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

could any one help me

Thnking in advance

Sanjeev N.A. Received on Fri Nov 17 2006 - 01:36:08 CST