TNS-03505: Failed to resolve name

HI

I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve name

my listerner.ora file is

LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=CHANDU))
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))
)

)

)

SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(SID_NAME=CHANDU)
(ORACLE_HOME=/oraeng/app/oracle/product/10.2.0)

)
)

and tnsnames.ora file is

MYALIAS=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))
)
(CONNECT_DATA=
(SID=CHANDU)
)
)

[oracle@chandu ~]$ tnsping MYALIAS

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 10-JUL-2008 00:47:48

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/oraeng/app/oracle/product/10.2.0/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

Please resolve my problem

Thanks
chandu

chandubtech
Profile Answers by chandubtech Questions by chandubtech
Jul 9th, 2008
4
11754

Questions by chandubtech answers by chandubtech

Database Admin

Answer

Showing Answers 1 - 4 of 4 Answers

hemantocp
Profile Answers by hemantocp

Sep 9th, 2008

There can be many reasons of this problem firstly plz check the Tnsnames.ora file and in this chk is there any space in the line of giving alias to connect descriptor i mean suppose ur serverice name is hhh then check there will not be empty space before the hhh in the line,

Another prob may be with the name of the database with which you want to conenct, check wheather the service name you are using in connect description is correct or not

bapiora
Profile Answers by bapiora

Jun 29th, 2009

If you have both database in same machine then you register both datbase service into listener, and register both db service in tns file as well and try to connect.

maniswamy
Profile Answers by maniswamy

Oct 3rd, 2009

Just check your port number if two database are in one PC the port number is changed.

mb.appsdba
Profile Answers by mb.appsdba

Sep 1st, 2010

The issue usually occurs when the tns entiries we provide has some unwanted characters or spaces etc.Please also check the tns entry(alias) is pointing to the correct database with sid,hostname etc.
If the same entry is been used by any other instance where it is working properly,better copy the entry and paste in your tnsnames.ora.
Then try once.Hopefully it should work.