Oracle EM重建
Oracle EM重建
在oracle 10g中，EM是一个很重要的管理工具，由于种种原因，而我们经常会出现无法访问EM的情况，例如以下：
1. Drop the dbcontrol
[oracle@localhost ~]$ emca -deconfig dbcontrol db
STARTED EMCA at Jul 7, 2010 7:39:51 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: primary
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 7, 2010 7:39:59 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/primary/emca_2010-07-07_07-39-51-PM.log.
Jul 7, 2010 7:40:01 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 7, 2010 7:40:18 PM
2. Drop the em repository.
[oracle@localhost admin]$ emca -repos drop
STARTED EMCA at Jul 7, 2010 8:06:28 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: primary
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 7, 2010 8:06:45 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/primary/emca_2010-07-07_08-06-28-PM.log.
Jul 7, 2010 8:06:45 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Jul 7, 2010 8:08:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 7, 2010 8:08:27 PM
3. Create EM Repository.
[oracle@localhost admin]$ emca -repos create
STARTED EMCA at Jul 7, 2010 8:13:21 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: primary
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 7, 2010 8:13:42 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/primary/emca_2010-07-07_08-13-21-PM.log.
Jul 7, 2010 8:13:42 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 7, 2010 8:16:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 7, 2010 8:16:56 PM
4. Config the DB control.
[oracle@localhost admin]$ emca -config dbcontrol db
STARTED EMCA at Jul 7, 2010 8:20:56 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: primary
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user: 8451
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
Database hostname ................ localhost
Listener port number ................ 1521
Database SID ................ primary
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 7, 2010 8:21:24 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/primary/emca_2010-07-07_08-20-56-PM.log.
Jul 7, 2010 8:21:33 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 7, 2010 8:23:20 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 7, 2010 8:23:20 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 7, 2010 8:25:02 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 7, 2010 8:25:02 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://localhost:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 7, 2010 8:25:02 PM
目录 返回
首页