emca -repos create 创建资料库时出现如下错误
SEVERE: Dbcontrol Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode.
使用emca -deconfig dbcontrol db -repos drop进行删除。
[oracle@oradb01 bin]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Jan 6, 2012 2:11:28 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/ora11g/cfgtoollogs/emca/orcl/emca_2012_01_06_14_11_28.log.
Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jan 6, 2012 2:15:46 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jan 6, 2012 2:15:48 PM
再用dbca的Configure Database Options重建EM即可
[oracle@oradb01 bin]$ dbca
dbca 重建好EM后,默认已经启动dbconsole
[oracle@oradb01 bin]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://oradb01:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
SEVERE: Dbcontrol Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode.
使用emca -deconfig dbcontrol db -repos drop进行删除。
[oracle@oradb01 bin]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Jan 6, 2012 2:11:28 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/ora11g/cfgtoollogs/emca/orcl/emca_2012_01_06_14_11_28.log.
Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Jan 6, 2012 2:11:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jan 6, 2012 2:15:46 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jan 6, 2012 2:15:48 PM
再用dbca的Configure Database Options重建EM即可
[oracle@oradb01 bin]$ dbca
dbca 重建好EM后,默认已经启动dbconsole
[oracle@oradb01 bin]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://oradb01:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.