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 18.104.22.168.2 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]$