Oracle RAC EM工具日常管理

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 

6 检查em运行状况

emctl status 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 ....................