This discussion is archived
9 Replies Latest reply: Feb 5, 2013 3:20 AM by 939018 RSS

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

apex_disco Newbie
Currently Being Moderated
Single Instance 10gR2 on Windows 2003 server

When I try to go to EM (from my omputer); I get a Enterprise Manager is not able to connect to the database instance and 3 green arrows showing Database Instance is open*, Listerner is Up* and Agent Connection to Instance Succeeded*.

When I log into the server and go to EM; I get a blank page.

I looked, stop and restarted DBConsole Services without any help.

I checked emctl status dbconsole and it says Enterprise Manager 10g is not running.

I did a EMCTL START DBCONSOLE and get ...
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://123.45.678.90:1234/em/console/AboutApplication
Agent Version     : 10.1.0.5.1
OMS Version       : 10.1.0.5.0
Protocol Version  : 10.1.0.2.0
Agent Home        : D:\oracle\product\10.2.0\db_1\123.45.678.90_blahblah
Agent binaries    : D:\oracle\product\10.2.0\db_1
Agent Process ID  : 2904
Agent Process ID  : 2904
Agent URL         : http://123.45.678.90:1234/em/console/emd/main
Started at        : 2011-09-27 08:49:49
Started by user   : SYSTEM
Last Reload       : 2011-09-27 08:49:49
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :      932
Size of XML files pending upload(MB)         :     5.17
Available disk space on upload filesystem    :    34.62%
Agent is already started. Will restart the agent
System error 1060 has occurred.

The specified service does not exist as an installed service. 
What happened and how do I fix it?
  • 1. Re: Enterprise Manager is not able to connect to the database instance.
    orawiss Oracle ACE
    Currently Being Moderated
    Please read MOS ID:

    Getting Error "The specified service does not exist as an installed service" When Trying To Restart Dbconsole [ID 785779.1]
    Trying to restart dbconsole results in the message "Agent is already started" and "system error 1060 - The specified service does not exist as an installed service".
  • 2. Re: Enterprise Manager is not able to connect to the database instance.
    apex_disco Newbie
    Currently Being Moderated
    I don't think that's the issue. I stopped all the services; waited 5 minutes, and started all services. And I have been waiting for more than 10 minutes now; EM still hasn't come up. I'm still getting the same message with EMCTL STATUS DBCONSOLE.

    Not sure if this helps - but one thing I have noticed is v$process increases rapidly from the time I started to now. When I first started, select count(*) from v$process* was 60; and now it's over 252. This is a test environment; it shouldn't have so much thing going on. I have changed it to 500 from 150; and it seems to continue to grow ... then the Agent Connection to Instance will fail.
  • 3. Re: Enterprise Manager is not able to connect to the database instance.
    Balazs Papp Expert
    Currently Being Moderated
    Not sure if this helps - but one thing I have noticed is v$process increases rapidly from the time I started to now. When I first started, select count(*) from v$process* was 60; and now it's over 252. This is a test environment; it shouldn't have so much thing going on. And it continues to go up in count ...
    happens for example when the EM repository is corrupt, and the database is flooded with connections with SYSMAN user
    but there could be several other reasons for this

    check the logs at
    $ORACLE_HOME/<hostname>_<SID>/sysman/log
    emagent.trc, emdctl.trc, emoms.trc
  • 4. Re: Enterprise Manager is not able to connect to the database instance.
    apex_disco Newbie
    Currently Being Moderated
    I see alot of errors on all 3 files you had mentioned. It is generating more as I am typing this.

    emoms.trc
    2011-09-27 10:28:58,519 [HttpRequestHandler-13330996] ERROR eml.OMSHandshake getParameterFromDB.563 - ORA-01403: no data found
    ORA-06512: at "SYSMAN.MGMT_USER", line 6613
    ORA-06512: at "SYSMAN.SETEMUSERCONTEXT", line 5
    ORA-06512: at line 1

    emagent.trc
    SQL = "/* OracleOEM */ BEGIN :succ_sub := 0; dbms_aqadm.enabl"...
    LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=123.45.678.90)(PORT=1234))(CONNECT_DATA=(SID=blahblah)))
    2011-09-27 10:29:01 Thread-1676 ERROR recvlets.aq: Error enabling user dbsnmp for aq agent 123_45_678_90_1234 on blahblah: ORA-24047: invalid agent name 123_45_678_90_1234, agent name should be of the form NAME
    ORA-06512: at line 1
    2011-09-27 10:29:01 Thread-1676 ERROR recvlets.aq: unable to create subscription on oracle_database blahblah
    2011-09-27 10:29:03 Thread-2388 ERROR upload: Error in uploadXMLFiles. Trying again in 300.00 seconds.

    emdctl.trc
    2011-09-27 09:53:39 Thread-1372 WARN http: snmehl_connect: connect failed to (123.45.678.90:1234): No connection could be made because the target machine actively refused it.
    (error = 10061)

    EDIT: Agent Connection to Instance has Failed. Count shows 499. Fail with the following error:
    ORA-12518: TNS:listener could not hand off client connection (DBD ERROR: OCIServerAttach)
  • 5. Re: Enterprise Manager is not able to connect to the database instance.
    apex_disco Newbie
    Currently Being Moderated
    The process count seems stable if I start all the services except DBCONSOLE. So, that sorts of confirm DBCONSOLE service is corrupt. Question is how do I fix it? I have tried DBCA and Configure Database Options but get message "No configuration is made, the database will not be updated. Click on OK button to return back to the wizard."

    Is there a need to reinstall just the DBCONSOLE? If so, how do I do it?

    Thanks.
  • 6. Re: Enterprise Manager is not able to connect to the database instance.
    EdStevens Guru
    Currently Being Moderated
    apex_disco wrote:
    The process count seems stable if I start all the services except DBCONSOLE. So, that sorts of confirm DBCONSOLE service is corrupt. Question is how do I fix it? I have tried DBCA and Configure Database Options but get message "No configuration is made, the database will not be updated. Click on OK button to return back to the wizard."

    Is there a need to reinstall just the DBCONSOLE? If so, how do I do it?

    Thanks.
    Configuring Database Control with EMCA
    http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/structure.htm#sthref73
  • 7. Re: Enterprise Manager is not able to connect to the database instance.
    HG75 Journeyer
    Currently Being Moderated
    emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create
  • 8. Re: Enterprise Manager is not able to connect to the database instance.
    apex_disco Newbie
    Currently Being Moderated
    Found this but for Oracle 11g. In the blog, he even removed the SYSMAN user. Is that advisable?
    http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/

    Edit: Tried emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create

    A few errors complaining about SYSMAN user already exists.

    Edited by: apex_disco on Sep 27, 2011 10:07 AM
  • 9. Re: Enterprise Manager is not able to connect to the database instance.
    939018 Newbie
    Currently Being Moderated
    SOLUTION:

    the problem was SYSMAN user locked, and I execute the following command

    SQL> alter user sysman account unlock;

    then it works.

    Edited by: 936015 on 05-Feb-2013 03:19

Legend

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