TNS-03505: Failed to resolve name

5 pts.
Tags:
Oracle 10g
Oracle error messages
Red Hat Enterprise Linux
RHEL4
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

I have not worked a lot with Linux, but have worked on other UNIX operating systems for numerous years.
Does the server/host have a valid IP address or hostname other than the loopback IP? Do you have a default domain?

I would suggest not using the loopback IP as your host. Is there a hostname for the server or does it have a valid IP address? you can look in the /etc/hosts file. You can also find domain information in the file: /etc/resolv.conf

When these questions can be answered, I would modify the listener.ora file to have a valid host. Also, I would likewise change the tnsnames.ora file to use that same host. Since this is just a home setup, I doubt you have issues with your domain…. but just in case, here is an entry of a “fully qualified” database for the tnsnames.ora file: database SID= PROD domain= acme.com

PROD.acme.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = prodserver.acme.com)(PORT = 1632))
)
(CONNECT_DATA =
(SERVICE_NAME = PROD.ACME.COM)
)
)

I hope this helps.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following