当前位置: > 数据库 > Oracle >

oracle11g重新安装oem

时间:2016-12-09 19:08来源:linux.it.net.cn 作者:IT
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 登陆后再次登陆,错误提示消失

(责任编辑:IT)
------分隔线----------------------------