oracle10g 重建em(命令行方式)

oracle10g 重建em(命令行方式)

1.查看dbconsole的状态

emctl status dbconsole

2.查看RAC数据库 dbcontrol 的配置信息

emca -displayConfig dbcontrol -cluster

3.清除RAC数据库旧的配置信息

emca -deconfig dbcontrol db -repos drop -cluster

4.重新建立RAC数据库的db control的配置信息

emca -config dbcontrol db -repos create -cluster

下面是具体修复过程

$ emca -repos drop

STARTED EMCA at Jul 4, 2007 2:48:11 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: hdsb1
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 4, 2007 2:48:23 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle10gRac/product/10.2.0/cfgtoollogs/emca/hdsb/emca_2007-07-04_02-48-11-AM.log.
Jul 4, 2007 2:48:23 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) …
Jul 4, 2007 2:57:22 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 4, 2007 2:57:22 AM

$ emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Jul 4, 2007 2:57:54 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database unique name: hdsb
Listener port number: 1521
Cluster name: hdsb
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 ……………. /oracle10gRac/product/10.2.0
Database instance hostname ……………. hdsb_db1
Listener port number ……………. 1521
Cluster name ……………. hdsb
Database unique name ……………. hdsb
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 4, 2007 2:58:35 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle10gRac/product/10.2.0/cfgtoollogs/emca/hdsb/emca_2007-07-04_02-57-54-AM.log.
Jul 4, 2007 2:58:37 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Jul 4, 2007 3:11:27 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 4, 2007 3:11:32 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /oracle10gRac/product/10.2.0/oc4j/j2ee/OC4J_DBConsole_hdsb_db1_hdsb1 to remote nodes …
Jul 4, 2007 3:11:33 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /oracle10gRac/product/10.2.0/oc4j/j2ee/OC4J_DBConsole_hdsb_db2_hdsb2 to remote nodes …
Jul 4, 2007 3:11:34 AM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating /oracle10gRac/product/10.2.0/oc4j/j2ee/isqlplus_hdsb_db1 to remote nodes …
Jul 4, 2007 3:11:35 AM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating /oracle10gRac/product/10.2.0/oc4j/j2ee/isqlplus_hdsb_db2 to remote nodes …
Jul 4, 2007 3:11:38 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /oracle10gRac/product/10.2.0/hdsb_db1_hdsb1 to remote nodes …
Jul 4, 2007 3:11:40 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /oracle10gRac/product/10.2.0/hdsb_db2_hdsb2 to remote nodes …
Jul 4, 2007 3:11:41 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Jul 4, 2007 3:13:33 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 4, 2007 3:13:33 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://XXXXXXXXX:1158/em <<<<<<<<<<<
Jul 4, 2007 3:13:33 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------
hdsb1 hdsb_db1 hdsb_db1
hdsb2 hdsb_db2 hdsb_db1

Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 4, 2007 3:13:33 AM

$ emca