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

[Database Administrator]

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@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.

[Database Administrator]

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@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)

[Database Administrator]

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@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)

[Database Administrator]

sanjeev wrote:
> 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@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.

For debugging, always try bypassing the TNS file and hardcode the
connection in the link.

First glance I would also make sure you can ping, and tnsping the host
before creating a link that directs to the tnsfile.

create database link
connect to scott identified by tiger
using
'(DESCRIPTION=(ADDRESS=(HOST=ADB)(PROTOCOL=TCP)(PO RT=1521))(CONNECT_DATA=(SERVICE_NAME=AVAYA.ADB)))' ;

[Database Administrator]

sanjeev wrote:
> 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@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.

For debugging, always try bypassing the TNS file and hardcode the
connection in the link.

First glance I would also make sure you can ping, and tnsping the host
before creating a link that directs to the tnsfile.

create database link
connect to scott identified by tiger
using
'(DESCRIPTION=(ADDRESS=(HOST=ADB)(PROTOCOL=TCP)(PO RT=1521))(CONNECT_DATA=(SERVICE_NAME=AVAYA.ADB)))' ;