How to Deconfigure Enterprise Manager Database Control

  • by
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 *