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

Questions by chandubtech   answers by chandubtech

Showing Answers 1 - 12 of 12 Answers

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

  Was this answer useful?  Yes

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. 

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions