oracle11g重新安装oem

1.重新设置sys sysman DBSNMP密码
alter user dbsnmp identified by **；

2.select 'drop public synonym '|| synonym_name || ';' from all_synonyms where synonym_name like 'MGMT_%';
select 'drop public synonym '|| synonym_name || ';' from all_synonyms where synonym_name like 'SMP_%';
select 'drop public synonym '|| synonym_name || ';' from all_synonyms where synonym_name like 'EMD_%';
select 'drop public synonym '|| synonym_name || ';' from all_synonyms where synonym_name like 'ECM_%';
全部删除同义词

3.drop user sysman cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
drop user MGMT_AVAILABILITY cascade;

4.emca -config dbcontrol db -repos create
重新安装提示输入3个账户密码和db信息后进行安装

 

5.安装后最后会出现错误提示，database contorl切换到非安全模式，按照提示操作即可
emctl stop dbconsole
emctl config emkey -repos -sysman_pwd sysman密码
emctl secure dbconsole -sysman_pwd sysman密码
emctl start dbconsole

6.登陆后会出现内部错误，点击数据库即可进入，使用sqlplus 登陆后再次登陆，错误提示消失