TNS-00515 Connect failed because target host or object does not exist
4joey1Mar 24 2011 — edited Mar 25 2011I have installed Oracle 11g on Oracle Enterprise Linux 5.5.During the installation,the OUI gave me an error that the listener could not start.I completed the installation and when I tried to start the listener with the command
lsnrctl start
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/joey-oel/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=joey_oel.com)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 111: Connection refused
Listener failed to start. See the error message(s) above...
Even after changing the tnsnames.ora host from (HOST=joey_oel.com) to the IP address 10.X.X.X i.e. (HOST=10.X.X.X) the exact same error appears.
How can I resolve this?