7 Replies Latest reply: Nov 27, 2012 8:42 AM by 969059 RSS

    Enterprise Manager starts then stops service.

    969059
      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
          One common solution for this situation is to reboot the whole DB server.
          • 2. Re: Enterprise Manager starts then stops service.
            969059
            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
              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
                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
                  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
                    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
                      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.