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.