Oracle RAC EM工具日常管理

来源：互联网发布：证件照换装软件编辑：程序博客网时间：2024/05/21 14:47

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

0 0