5 Replies Latest reply: Feb 12, 2013 8:20 AM by sb92075 RSS

    Unable to configure Enterprise Manger -11gr2 - Windows

    IamHariKrishna
      Guys -

      11gr2 on a windows 2005,64 bit server. Please have a look below and suggest me how to setup EM to monitor database.

      C:\Users\administrator.DEKATELDMN>set oracle_home=C:\Oracle\Products\11gR2

      C:\Users\administrator.DEKATELDMN>emca -config dbcontrol db -repos create

      STARTED EMCA at 11-feb-2013 10:14:51
      EM Configuration Assistant, Version 11.2.0.0.2 Production
      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      Enter the following information:
      Database SID: rator
      11-feb-2013 10:14:56 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
      WARNING: ORA-01031: utilstrµkkelige privilegier

      11-feb-2013 10:14:56 oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
      SEVERE: Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.

      Some of the possible reasons may be :

      1) Database may not be up.
      2) Database is started setting environment variable ORACLE_HOME with trailing '/'. Reset ORACLE_HOME and bounce the database.

      For eg. Database is started setting environment variable ORACLE_HOME=/scratch/db/ . Reset ORACLE_HOME=/scratch/db and bounce the database.

      Thanks
        • 1. Re: Unable to configure Enterprise Manger -11gr2 - Windows
          Osama_Mustafa
          EVERE: Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.
          Did you check if the database is up ,

          set ORACLE_SID=
          sqlplus / as sysdba
          select open_mode from v$database ;

          COPY & PASTE Output
          • 2. Re: Unable to configure Enterprise Manger -11gr2 - Windows
            IamHariKrishna
            C:\Users\administrator>set oracle_sid=rator

            C:\Users\administrator>sqlplus sys/rator as sysdba

            SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 12 11:07:10 2013

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


            Connected to:
            Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
            With the Partitioning, OLAP, Data Mining and Real Application Testing options

            SQL> select open_mode from v$database ;

            OPEN_MODE
            --------------------------------------------------------------------------------
            READ WRITE

            Still im unable to configure EM in 11gr2. not sure why. any idea?
            • 3. Re: Unable to configure Enterprise Manger -11gr2 - Windows
              Osama_Mustafa
              Check MOS note
              EMCA fails with "SEVERE: Database instance unavailable" [ID 750697.1]
              • 4. Re: Unable to configure Enterprise Manger -11gr2 - Windows
                IamHariKrishna
                Osama, I have followed that doc and referred few other mosc docs but no luck. I am getting same error message again and again.

                C:\Users\administrator>set oracle_sid=RATOR

                C:\Users\administrator>emca -config dbcontrol db -repos recreate

                STARTED EMCA at 12-feb-2013 13:37:08
                EM Configuration Assistant, Version 11.2.0.0.2 Production
                Copyright (c) 2003, 2005, Oracle. All rights reserved.

                Enter the following information:
                Database SID: RATOR
                12-feb-2013 13:37:14 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                WARNING: ORA-01031: utilstrµkkelige privilegier

                12-feb-2013 13:37:14 oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
                SEVERE:
                Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.

                Some of the possible reasons may be :

                1) Database may not be up.
                2) Database is started setting environment variable ORACLE_HOME with trailing '/'. Reset ORACLE_HOME and bounce the database.

                For eg. Database is started setting environment variable ORACLE_HOME=/scratch/db/ . Reset ORACLE_HOME=/scratch/db and bounce the database.
                • 5. Re: Unable to configure Enterprise Manger -11gr2 - Windows
                  sb92075
                  issue following OS commands

                  lsnrctl status
                  lsnrctl service


                  COPY the results from abvove, then PASTE all back here