000028205 - B-1109 - Unable to start Oracle listener

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028205
Applies ToAffected Versions: All Versions
ResolutionThe Oracle listener does not start, which means that the database is not available and the ACM UI login page is not displayed
The most common cause for this is that the ORACLE_HOME and ORACLE_SID variables are not correctly set or they are in the oracle users .bash_profile
ORACLE_SID=AVDB
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1
The /home/oracle/.bash_profile should source the /home/oracle/setDeployEnv.sh where the above variables should be set
The status of the Oracle listener can be seen by using the lsnrctl status command.
ex. $ lsnrctl status
if the Listener is up and available, you will see something like the following:


$ lsnrctl status



LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 28-SEP-2009 20:43:30



Copyright (c) 1991, 2005, Oracle. All rights reserved.



Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=appliance2900.aveksa.local)(PORT=1555)))


STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.2.0 - Production

Start Date 28-SEP-2009 11:27:45

Uptime 0 days 9 hr. 15 min. 44 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=appliance2900.aveksa.local)(PORT=1555)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "AVDB" has 1 instance(s).

Instance "AVDB", status READY, has 1 handler(s) for this service...

Service "AVDBXDB" has 1 instance(s).

Instance "AVDB", status READY, has 1 handler(s) for this service...

Service "AVDB_XPT" has 1 instance(s).

Instance "AVDB", status READY, has 1 handler(s) for this service...

The command completed successfully


 

Attachments

    Outcomes