Seek The Sun Slowly

Q by Oda

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

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

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.

Original Address: http://itknowledgeexchange.techtarget.com/itanswers/tns-03505-failed-to-resolve-name/