How to rebuild dbconsole?

Sometimes, dbconsole do not work and needs to be rebuilt without recreating the repository. This is fast and easy for Oracle 10.2.x. Run the following command to remove the existing Database Control configuration:

$ORACLE_HOME/bin/emca -deconfig dbcontrol db

You may also want to change the hostname. For that, export the ORACLE_HOSTNAME with the hostname you need, before re-creating the Database Control configuration:

export ORACLE_HOSTNAME=yourhostname

Run the following command to recreate the Database Control configuration whilst leaving the Database Control repository intact:

$ORACLE_HOME/bin/emca -config dbcontrol db

If you need to drop the Database Control configuration and repository:

$ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop

Note: When running ‘emca -config dbcontrol db -repos recreate’ or ‘emca -deconfig dbcontrol db -repos drop’ to recreate or drop the Enterprise Manager Database Control configuration files and repository the operation hangs and at the same time users are not able to login to the database. The database is put in quiesce mode. This is applicable only for 10g and 11.1 database release.Starting from 11.2.0.1 database release the database is not put into quiesce mode. To recreate the Database Control configuration and repository:

$ORACLE_HOME/bin/emca -config dbcontrol db -repos create

Note that if you have configured your dbconsole before 1/1/2011, you will have to install patch 8350262 to update a certificate wich expiration date is 12/31/2010.

To unquiesce the database, log in as sysdba:

SQL> select active_state from v$instance;

ACTIVE_ST

---------

QUIESCED

SQL> alter system unquiesce;

System altered.

SQL> select active_state from v$instance;

ACTIVE_ST

---------

NORMAL

Finally, another interesting tip on dbconsole: when you get “Failed to shutdown DBConsole Gracefully” message when trying to shut it down, you can try to remove emctl.pid file from $ORACLE_HOME/hostname_sid directory and retry.