1 Reply Latest reply: Nov 27, 2012 6:59 AM by Neill_R RSS

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

    Neill_R
      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