Skip to content
Home » Oracle Database » How to Deconfigure Enterprise Manager Database Control

How to Deconfigure Enterprise Manager Database Control

Before installing Grid or Cloud Control, you must deconfigure the original dbconsole from the repository that Grid Control resides in. Let's see an example, in which, the dbconsole of a cluster database needs to be deconfigured.
[oracle@primary01 ~]$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop -cluster -SYS_PWD <password> -SYSMAN_PWD <password>


STARTED EMCA at Dec 26, 2012 9:27:04 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database unique name: compdb
Service name: primdb.example.com
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 26, 2012 9:27:31 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/compdb/emca_2012_12_26_09_27_03.log.
Dec 26, 2012 9:27:39 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Dec 26, 2012 9:28:01 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 26, 2012 9:40:56 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 26, 2012 9:41:05 AM

For a standalone database, please remove "-cluster" in the command line.

Let's see another example which is a standalone database in Traditional Chinese on Windows Server.
C:UsersAdministrator>emca -deconfig dbcontrol db -repos drop -SYS_PWD <password> -SYSMAN_PWD <password>

啟動 EMCA 的時間 2013/1/28 上午 10:44:15
EM 組態輔助程式, 版本 11.2.0.0.2 Production 版
版權所有 (c) 2003, 2005, Oracle.  保留一切權利.

請輸入下列資訊:
資料庫 SID: orcl
監聽器連接埠號碼: 1521

要繼續? [yes(Y)/no(N)]: y
2013/1/28 上午 10:46:05 oracle.sysman.emcp.EMConfig perform
資訊: 已將這項作業記錄於 C:appAdministratorcfgtoollogsemcaorclemca_2013_01
_28_10_44_15.log.
2013/1/28 上午 10:46:05 oracle.sysman.emcp.util.DBControlUtil stopOMS
資訊: 正在停止 Database Control (這可能需要一些時間) ...
2013/1/28 上午 10:46:37 oracle.sysman.emcp.EMReposConfig invoke
資訊: 正在刪除 EM 儲存區域 (可能需要一些時間) ...
2013/1/28 上午 10:48:32 oracle.sysman.emcp.EMReposConfig invoke
資訊: 已順利刪除儲存區域
已順利完成 Enterprise Manager 組態設定
完成 EMCA 的時間 2013/1/28 上午 10:48:34

C:UsersAdministrator>

Leave a Reply

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