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 登陆后再次登陆,错误提示消失

上一篇:Android 自定义Android带图片和文字的ImageButton


下一篇:【lazy标记得思想】HDU3635 详细学习并查集