This discussion is archived
1 Reply Latest reply: Nov 27, 2012 4:59 AM by Neill_R RSS

Enterprise Manager is not able to connect to the database instance. The sta

Neill_R Newbie
Currently Being Moderated
Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.


Listener is shown as unavailable.

lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-NOV-2012 11:52:40

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=freds-server.i-surname.co.uk)(PORT=1521)))

STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 27-NOV-2012 11:50:02
Uptime 0 days 0 hr. 2 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/11g/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/freds-server/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=freds-server)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=freds-server)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "GWORCL.i-surname.co.uk" has 2 instance(s).
Instance "GWORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "GWORCL", status READY, has 1 handler(s) for this service...
Service "GWORCLXDB.i-status.co.uk" has 1 instance(s).
Instance "GWORCL", status READY, has 1 handler(s) for this service...
The command completed successfully


I suspect that this is not just an OEM issue.

see

Listener working but not working for Enterprise manager oracle 11gr2 Linux.

for configuration files

Edited by: Neill_R on Nov 27, 2012 11:51 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points