最近在倒腾Oracle,把EM给搞挂了,害我又得重新弄半天。
1. emca -deconfig dbcontrol db
进行查询
2. emca -repos drop
删除repository
如果删除错误,手动执行删除相关用户和权限
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
3. emca -config dbcontrol db -repos create
重新创建Database Control
期间需要输入用户DBSNMP和SYSMAN的密码,我也不清楚它们的初始密码是什么。只有来自己改
SQL> alter user dbsnmp identified by dbsnmp;
备份并修改%oracle_home%/sysman/config/emoms.properties
oracle.sysman.eml.mntr.emdRepPwd=sysman
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE
备份并修改%oracle_home%/sysman/emd/targets.xml
附上几个有用的参考
集群环境下
http://space.itpub.net/9252210/viewspace-605035