Removing Database Control (dbconsole) from a database

Oracle Database 10g introduced Database Control (dbconsole) to aid in day to day administration tasks and monitoring. When building a database for use as a repository for Oracle Enterprise Manager Grid Control or the recently released Oracle Enterprise Manager Cloud Control 12c, you will need to remove Database Control and its associated repository from the database.

This document will detail the steps to remove Database Control from Oracle Enterprise 11gR2 database on Oracle Enterprise Linux 5.5.

Using the Enterprise Manager Configuration Assistant (EMCA) pass the deconfig dbcontrol db command with the –repos drop option. If you are removing Database Control from a RAC database add the –cluster option. You will need to provide the database SID, listener port number and passwords for both the SYS and SYSTEM user.

[oracle@cloudctl bin]$ cd ~
[oracle@cloudctl ~]$ cd $ORACLE_HOME/bin
[oracle@cloudctl bin]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Oct 7, 2011 12:18:19 PM
EM Configuration Assistant, Version Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: oemrepos
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y
Oct 7, 2011 12:19:02 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/oemrepos/emca_2011_10_07_12_18_19.log.
Oct 7, 2011 12:19:03 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Oct 7, 2011 12:19:24 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Oct 7, 2011 12:20:59 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 7, 2011 12:21:01 PM
[oracle@cloudctl bin]$

Leave a Reply

Your email address will not be published. Required fields are marked *