Monday, April 2, 2012

Oracle 11g EM DBconsole: WARNING: Database instance unavailable

Hello,


If you are receiving above error when accessing the DBConsole it is possible that there is some problem with EM repository.


It is always better to drop the em repository and deconfig all your database running in cluster or non-cluster mode.


Below are the steps that you can use.


  • emca -deconfig all db


Note: Above command will be used for all the ORACLE_SID running on the node and use below command for the last one.


  • emca -deconfig all db -repos drop
Now before creating a repository make sure that you have set below parameters:
  1. ORACLE_SID
  2. ORACLE_UNQNAME
  3. ORACLE_HOSTNAME
  4. ORACLE_HOME
  5. GRID_HOME
  • emca -config dbcontrol db -repos create -cluster -EM_NODE_LIST dbnode1,dbnode2
Now, without using the -repos create execute the command mentioned below to add the rest of the databases.
  • emca -config dbcontrol db -cluster -EM_NODE_LIST dbnode1,dbnode2
Please feel free to contact me if you are facing me an issue.

1 comment:

  1. D:\app\n\product\11.2.0\dbhome_1\BIN>emca -deconfig all db

    STARTED EMCA at Jan 18, 2013 12:52: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: orcl

    Do you wish to continue? [yes(Y)/no(N)]: y
    Jan 18, 2013 12:52:30 AM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at D:\app\n\cfgtoollogs\emca\emca_2013_01_18_00_52_24.log.
    Jan 18, 2013 12:52:30 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Database instance unavailable.
    Refer to the log file at D:\app\n\cfgtoollogs\emca\emca_2013_01_18_00_52_24.log for more details.
    Could not complete the configuration. Refer to the log file at D:\app\n\cfgtoollogs\emca\emca_2013_01_18_00_52_24.log for more details.

    ReplyDelete