Posted by NosaLee in Oracle on 27-06-2012. Tags: Oracle Database Experience, Oracle FAQ, Oracle Q & A, Oracle Skills
Q by Oda
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
and tnsnames.ora file is
[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:
TNS-03505: Failed to resolve name
Please resolve my problem
Re by Jcmdba
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
(ADDRESS = (PROTOCOL = TCP)(HOST = prodserver.acme.com)(PORT = 1632))
(SERVICE_NAME = PROD.ACME.COM)
I hope this helps.
Original Address: http://itknowledgeexchange.techtarget.com/itanswers/tns-03505-failed-to-resolve-name/