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
Software/Hardware used:
Software/Hardware used:
ASKED:
July 9, 2008 7:29 PM
UPDATED:
July 11, 2008 9:13 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
