重新配置Oracle EM

最近在倒腾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

<Property NAME="UserName" VALUE="DBSNMP" ENCRYPTED="FALSE"/>
<Property NAME="password" VALUE="dbsnmp" ENCRYPTED="FALSE"/>

 

附上几个有用的参考

http://blog.163.com/ansel_zlh/blog/static/10372717200811491437555/
http://hi.baidu.com/blackbear008/blog/item/90b5d2a73e9a159ed0435823.html

集群环境下

http://space.itpub.net/9252210/viewspace-605035