总是遇EM损坏的情况,自己总结的简单的三步解决(11g)EM重建,经过自己多次实践很好用,现贴出来给大家参考。
1.删除EM配置
emca -deconfig dbcontrol db -repos drop
2.删除em相关用户
drop user SYSMAN cascade;
drop user MGMT_VIEW cascade;
drop role MGMT_USER;
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.重建EM
emca -config dbcontrol db -repos create
之后的步骤根据提示一步步完成即可。
4.启停服务
先设置ORACLE_SID
emctl start dbconsole
emctl stop dbconsole
emctl status dbconsole