1 检查em集群配置:
emca -displayConfig dbcontrol -cluster
2 创建em集群配置:
emca -config dbcontrol db - repos create -cluster
3 重新创建em集群配置:
3.1 删除早期DBCONSOLE创建的用户:
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
drop user sysman cascade;
3.2 删除早期DBCONSOLE创建的对象:
drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
drop public synonym SETEMVIEWUSERCONTEXT;
drop public synonym MGMT_AVAILABILITY;
drop public synonym MGMT_CURRENT_AVAILABILITY;
drop public synonym MGMT_SEVERITY_OBJ
3.3 重建
emca -config dbcontrol db - repos recreate -cluster 注:recreate很重要,重建不要忘记了,另外需要删除一些以前创建的:
4 启动em:
emctl start dbconsole
5 关闭em:
emctl stop dbconsole
测试如下:
[oracle@rac1 emd]$ emca -displayConfig dbcontrol -cluster
STARTED EMCA at Dec 9, 2015 10:21:13 PM
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: rac
Service name: rac
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 9, 2015 10:21:23 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/rac/emca_2015_12_09_22_21_11.log.
Dec 9, 2015 10:21:38 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------
rac rac1 rac1
rac rac2 rac1
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 9, 2015 10:21:39 PM
[oracle@rac1 emd]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://rac1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ....................