This discussion is archived
7 Replies Latest reply: Nov 27, 2012 6:42 AM by 969059 RSS

Enterprise Manager starts then stops service.

969059 Newbie
Currently Being Moderated
I have been reading a lot of forum posts about issues people are having Enterprise Manager. I've gotten some ideas from them but not a solid solution. So perhaps there's someone out there who has seen this:

Oracle 10.2 with most recent CPU (Oct 15th 2012) running on a windows 2003 server.
Users are able to connect to database via custom web application and I am able to connect to isqlplus via workstation.
However I am not able to connect to Enterprise manager directly on server or at workstation.

When I run lsnctl status I get the following: (please note that I have put xx in for the hostname for privacy reasons)


LSNRCTL for 32-bit Windows: Version 10.2.0.5.0 - Production on 15-NOV-2012 09:05
:29

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PICAA0LCSDPUB.xx.xx.xx.xx)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.5.0 - Produ
ction
Start Date 31-OCT-2012 12:11:18
Uptime 14 days 21 hr. 54 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File e:\oracle\ora10.2\network\admin\listener.ora
Listener Log File e:\oracle\ora10.2\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PICAA0LCSDPUB.xx.xx.xx.xx)(PORT=
1521)))
Services Summary...
Service "siber.xx.xx.xx.xx" has 2 instance(s).
Instance "siber", status READY, has 2 handler(s) for this service...
Instance "siber.xx.xx.xx", status UNKNOWN, has 1 handler(s) for this se
rvice...
Service "siber_XPT.xx.xx.xx.xx" has 1 instance(s).
Instance "siber", status READY, has 2 handler(s) for this service...
The command completed successfully

emctl status dbconsole returns the following:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
http://PICAA0LCSDPUB.xx.xx.xx.xx:5501/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.

emctl start dbconsole returns the following:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
http://PICAA0LCSDPUB.xx.xx.xx.xx:5501/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The requested service
has already been started.

More help is available by typing NET HELPMSG 2182.

When I try to access the enterprise manager I get the windows cannot find server/page cannot be displayed...

I have noticed that when I do a netstat I do not see a port 5501 listed.

I kind of walked into a position with this problem. I've some exp with oracle but (obviously) not an expert by any means.

Any help appreciated!

Thanks
Kevin
  • 1. Re: Enterprise Manager starts then stops service.
    sb92075 Guru
    Currently Being Moderated
    One common solution for this situation is to reboot the whole DB server.
  • 2. Re: Enterprise Manager starts then stops service.
    969059 Newbie
    Currently Being Moderated
    That was one of the first things I tried. Was having this issue before I updated. Restarted entire system from powered down state.
  • 3. Re: Enterprise Manager starts then stops service.
    sb92075 Guru
    Currently Being Moderated
    kkostic wrote:
    That was one of the first things I tried. Was having this issue before I updated. Restarted entire system from powered down state.
    Then the next alternative is to essentially wipe out the repository & rebuild a new one

    http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/
  • 4. Re: Enterprise Manager starts then stops service.
    969059 Newbie
    Currently Being Moderated
    Thanks for that link. Will try this when I can take the system down again.

    Does it make any sense that the listener seems to work and/or I can get into isqlplus but not enterprise manager?
  • 5. Re: Enterprise Manager starts then stops service.
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Try to Recreate it again
    emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create
  • 6. Re: Enterprise Manager starts then stops service.
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,

    Take a look at this http://naveenkumarsr.wordpress.com/2010/10/06/manually-configuring-deconfiguring-oem/

    Also, FYI...you can use DBCA as well to configure OEM.
  • 7. Re: Enterprise Manager starts then stops service.
    969059 Newbie
    Currently Being Moderated
    Thanks for the previous replies. Apparently the oracle drive filled up before I was handed the database duties. Corrupted the emoms.properties file as well as some other console items. using emca command to drop wasn't working. Had to use the following manual drop procedure:

    DBConsole repository can be dropped manually by executing following SQL statements.

    Step 1: Drop AQ related objects in the SYSMAN schema
    Logon SQLPLUS as user SYS
    SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force=>TRUE);

    Step 2: Drop the DB Control Repository Objects
    Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects:
    SQL> SHUTDOWN IMMEDIATE;
    SQL> STARTUP RESTRICT;
    SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
    SQL> EXEC sysman.setEMUserContext('',5);
    SQL> REVOKE dba FROM sysman;
    SQL> DECLARE
    CURSOR c1 IS
    SELECT owner, synonym_name name
    FROM dba_synonyms
    WHERE table_owner = 'SYSMAN';
    BEGIN
    FOR r1 IN c1 LOOP
    IF r1.owner = 'PUBLIC' THEN
    EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
    ELSE
    EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
    END IF;
    END LOOP;
    END;
    +/+
    SQL> DROP USER mgmt_view CASCADE;
    SQL> DROP ROLE mgmt_user;
    SQL> DROP USER sysman CASCADE;
    SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;
    How to delete DBConsole configuration files manually?

    To manually delete DBConsole configuration files, remove the following directories from the filesystem:

    +<ORACLE_HOME>/<hostname_sid>+
    +<ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>+

    If the dbcontrol is upgraded from lower version, for example, from 10.2.0.3 to 10.2.0.4, then the following directory also needs to be removed


    from the file system.
    +<ORACLE_HOME>/<hostname_sid>.upgrade+
    +<ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>.upgrade+

    NOTE : Be careful while removing these directories as one should NOT remove OC4J_DBConsole or any other directory by mistake, they are very


    important. You need to delete only those directories with <hostname>_<sid> where hostname is the hostname of the server and SID should be the


    database SID.

    On Windows you also need to delete the DB Console service:
    Using regedit
    - run regedit
    - navigate to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services
    - locate the OracleDBConsole<sid> entry and delete it
    Or
    On Windows XP and Windows Server 2003 you can run the following from the command line:
    CMD> sc delete <service_name>
    - where <service_name> is the DB Control service name (typically: OracleDBConsole<sid>)
    Or
    CMD> nmesrvops delete <servicename>
    - where <service_name> is the DB Control service name (typically: OracleDBConsole<sid>)Then I could use emca command to rebuild and configure the dbconsole.



    After this I was able to recreate the dbconsole and everything worked.

Legend

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