2 Replies Latest reply on Nov 2, 2012 2:05 PM by user2420150

    Dbconsole not started and EM does not work

    user2420150
      Recently we changed domain name from xxx.net to yyy.net, then DB console is no long working. I have changed all entries(I hope) related to domain to the new one and still not working. My oracle is 11gR2 and OS is window server 2008 R2 with 64 bit. The latest error message is as below:

      PS C:\Windows\system32> emctl start dbconsole
      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
      Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
      https://MD-ORCL3.perkinelmer.net:1158/em/console/aboutApplication
      Starting Oracle Enterprise Manager 11g Database Control ...The OracleDBConsolemdorcl3 service is starting...............

      The OracleDBConsolemdorcl3 service could not be started.

      A service specific error occurred: 2.
      More help is available by typing NET HELPMSG 3547.

      Then I tried:

      PS C:\Windows\system32> NET HELPMSG 3547

      A service specific error occurred: ***.

      Then I tried:

      PS C:\Windows\system32> emca -config dbcontrol db -repos drop

      STARTED EMCA at Nov 1, 2012 10:37:19 AM
      EM Configuration Assistant, Version 11.2.0.0.2 Production
      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      Enter the following information:
      Database SID: MDORCL3
      Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
      at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
      at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
      at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
      at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
      at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
      at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
      at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)


      PS C:\Windows\system32> emca -config dbcontrol db -repos recreate

      STARTED EMCA at Nov 1, 2012 10:49:24 AM
      EM Configuration Assistant, Version 11.2.0.0.2 Production
      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      Enter the following information:
      Database SID: MDORCL3
      Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
      at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
      at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
      at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
      at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
      at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
      at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
      at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)


      I am totally lost since the instance with SID = MDORCL3 is still running.

      Any thought and help is greatly appreciated!
        • 1. Re: Dbconsole not started and EM does not work
          Satishbabu Gunukula
          Did you refer below mentalink note?

          Creating dbconsole 11.2 fails with "Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable" on Windows [ID 1332546.1]

          Regards,
          http://www.oracleracexpert.com
          Overview of Transparent Application Failover in Oracle RAC
          http://www.oracleracexpert.com/2010/04/overview-of-transparent-application.html
          Learn on Oracle Certification
          http://www.oracleracexpert.com/2009/08/certification.html
          • 2. Re: Dbconsole not started and EM does not work
            user2420150
            I also checked that:

            PS C:\Windows\system32> emctl status agent
            Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
            Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
            ---------------------------------------------------------------
            Agent is Not Running


            How to force to start agent?


            I will read through following information

            http://www.oracleracexpert.com
            Overview of Transparent Application Failover in Oracle RAC
            http://www.oracleracexpert.com/2010/04/overview-of-transparent-application.html
            Learn on Oracle Certification
            http://www.oracleracexpert.com/2009/08/certification.html