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)
| 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) |