Oracle 11gR2 Enterprise manager problem

Question

I joined a company as a fresher DBA and in testing server there is weird problem.

My listener is running very well and developers can connect remotely to database but whenever I tried to start enterprise manager it shows me error like:

Listener status down. The listener "(Listener name)" is not running using the Listener parameter file: "D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin/listener.ora" on Host: "(Hostname)" at Port: "1521".

When I write emctl status dbconsole it shows me:

C:\Windows\system32>emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. https://(HOSTNAME):5500/em/console/aboutApplication Oracle Enterprise Manager 11g is running.

Logs are generated in directory D:\app\dbadmin\product\11.2.0\dbhome_1/(Hostname)_(Listenername)/sysman/log

Here is my listener.ora file:

(Listener Name) =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = (Hostname))(PORT = 1521))
    )
  )

lsnrctl status:

 LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 10-JUL-2018 14:33:08

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                02-JUN-2018 19:18:22
Uptime                    37 days 19 hr. 14 min. 57 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         d:\app\dbadmin\diag\tnslsnr\ESTDEV03\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ESTDEV03)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "********" has 1 instance(s).
  Instance "*******", status READY, has 1 handler(s) for this service...
Service "******" has 1 instance(s).
  Instance "******", status READY, has 1 handler(s) for this service...
The command completed successfully.

TNSPING Result:

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-JUL-2018 10:16:01

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = (Service Name))))
OK (20 msec)

TNSNAMES.ORA File:

# tnsnames.ora Network Configuration File: D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

(Listener Name)=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = (service name))
    )
  )

(Listener Name) =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

I asked old DBA but he was not able to find a solution.
So can you please tell me where is a problem?

Answer 1

Try resetting the local agent:

> emctl stop agent

> emctl clearstate agent

> emctl start agent