如何手工重建10g database console

以下紅色字型表示要求我們輸入的資訊。
1) 使用emca -deconfig dbcontrol db命令刪除db console的配置：
[oracle@ocm ~]$ emca -deconfig dbcontrol db

STARTED EMCA at Sep 4, 2007 5:00:09 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: prod

Do you wish to continue? [yes(Y)/no(N)]: yes
Sep 4, 2007 5:00:18 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-00-09-PM.log.
Sep 4, 2007 5:00:20 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:00:46 PM

2) 使用emca -repos drop刪除EM資訊庫
[oracle@ocm ~]$ emca -repos drop

STARTED EMCA at Sep 4, 2007 5:01:10 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: prod
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:01: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/prod/emca_2007-09-04_05-01-09-PM.log.
Sep 4, 2007 5:01:24 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Sep 4, 2007 5:05:19 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:05:19 PM

3) 使用emca -repos create來建立資訊庫
[oracle@ocm ~]$ emca -repos create

STARTED EMCA at Sep 4, 2007 5:06:42 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: prod
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:06:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-06-42-PM.log.
Sep 4, 2007 5:06:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 4, 2007 5:12:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:12:17 PM

4) 使用emca -config dbcontrol db建立配置資訊
[oracle@ocm ~]$ emca -config dbcontrol db

STARTED EMCA at Sep 4, 2007 5:13:16 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: prod
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
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 ................ ocm
Listener port number ................ 1521
Database SID ................ prod
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:13:39 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/e                          mca_2007-09-04_05-13-16-PM.log.
Sep 4, 2007 5:13:40 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
Sep 4, 2007 5:13:55 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 4, 2007 5:15:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 4, 2007 5:15:57 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://ocm:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:15:58 PM

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9842/viewspace-349433/，如需轉載，請註明出處，否則將追究法律責任。