Oracle : Connect Failed Because Target Host or Object Does Not Exist
December 25 2014
We have already discussed about install Oracle 11g and error fix. This post describe errors and solutions.
Error :
# /etc/init.d/oracle-xe status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-NOV-2013 08:56:13
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=chakraisus.cloudmin.localdomain)(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
Find the error with lsnrctl command,
# lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-NOV-2013 09:00:10
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/host/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=chakraisus.cloudmin.localdomain)(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
Listener failed to start. See the error message(s) above...
Find the listener.ora file using find command,
# find /u01/. -name 'listener.ora'
/u01/./app/oracle/product/11.2.0/xe/network/admin/listener.ora
/u01/./app/oracle/product/11.2.0/xe/network/admin/samples/listener.ora
rename the listener.ora and restart the oracle server or give the command to start
# cd /u01/app/oracle/product/11.2.0/xe/network/admin
# mv listener.ora listener.ora_bak
# lsnrctl start
# lsnrctl status
# mv listener.ora listener.ora_bak
# lsnrctl start
# lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-NOV-2013 11:04:36
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 05-NOV-2013 09:25:49
Uptime 0 days 1 hr. 38 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/host/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.gourmeda.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.gourmeda.com)(PORT=8090))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
Check the oracle netstat
# netstat -anp | grep oracle
tcp 0 0 ::ffff:124.153.121.157:1521 ::ffff:122.164.217.18:15659 ESTABLISHED 27994/oracleXE
tcp 0 0 ::ffff:124.153.121.157:1521 ::ffff:122.164.217.18:15780 ESTABLISHED 28059/oracleXE
unix 2 [ ACC ] STREAM LISTENING 172239 21545/tnslsnr /var/tmp/.oracle/s#21545.1
unix 2 [ ACC ] STREAM LISTENING 172241 21545/tnslsnr /var/tmp/.oracle/s#21545.2
unix 3 [ ] STREAM CONNECTED 189800 24537/xe_d000_XE /var/tmp/.oracle/s#24537.1
unix 3 [ ] STREAM CONNECTED 185691 24537/xe_d000_XE /var/tmp/.oracle/s#24537.1
If its not start perfectly check your $ORACLE_HOME path set correctly,
# echo $ORACLE_HOME;
/u01/app/oracle/product/11.2.0/xe
You have mail in /var/spool/mail/root
solution 1:
you have to check the host name with ip address in /etc/hosts/
Finally kill oracle process start and check the status,
# /etc/init.d/oracle-xe status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 06-NOV-2013 17:02:56
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 06-NOV-2013 17:02:32
Uptime 0 days 0 hr. 0 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/user/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kvic-kimis.cloudmin.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=user.cloudmin.localdomain)(PORT=8090))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
Hi Thanks for your suggestion. It worked. I read the same advice from another forum I renamed the listener file to listener and restarted the database. Magically the listener is working. Now my question is do I need listener file for Oracle x press edition? If needed, how do I create a listener file which will work? Appreciate your help. Regards
Thanks !!! Listener file created automatically, If you want to update can do in that specific location.