服务器之家

服务器之家 > 正文

oracle 11g em重建报唯一约束错误解决方法

时间:2019-11-15 15:41     来源/作者:oracle教程网

今天在手工配置Oracle11g的EM时总是报如下错误: 
WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated 
ORA-06512:at"SYSMAN.EMD_LOADER",line4986 
ORA-06512:atline1 
以Metalink上也没有找到解决办法,以下是我的解决过程: 

1、数据库版本 
SQL>select*fromv$version; 
BANNER 
------------------------------------------------------------------------------------------------------------------------------ 
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction 
PL/SQLRelease11.2.0.3.0-Production 
CORE11.2.0.3.0Production 
TNSforLinux:Version11.2.0.3.0-Production 
NLSRTLVersion11.2.0.3.0–Production 

2、配置EM时的步骤 
[oracle@Core-Nbu-Rollback~]$emca-configdbcontroldb-reposrecreate 
STARTEDEMCAatNov23,20123:52:08PM 
EMConfigurationAssistant,Version11.2.0.3.0Production 
Copyright(c)2003,2011,Oracle.Allrightsreserved. 
Enterthefollowinginformation: 
DatabaseSID:test 
DatabaseControlisalreadyconfiguredforthedatabasetest 
YouhavechosentoconfigureDatabaseControlformanagingthedatabasetest 
Thiswillremovetheexistingconfigurationandthedefaultsettingsandperform.afreshconfiguration 
---------------------------------------------------------------------- 
WARNING:Whilerepositoryisdroppedthedatabasewillbeputinquiescemode. 
---------------------------------------------------------------------- 
Doyouwishtocontinue?[yes(Y)/no(N)]:Y 
ListenerORACLE_HOME[/soft/ora11g/11202]: 
PasswordforSYSuser: 
PasswordforDBSNMPuser: 
PasswordforSYSMANuser: 
Emailaddressfornotifications(optional): 
OutgoingMail(SMTP)serverfornotifications(optional): 
----------------------------------------------------------------- 
Youhavespecifiedthefollowingsettings 
DatabaseORACLE_HOME................/soft/ora11g/11202 
Localhostname................Core-Nbu-Rollback 
ListenerORACLE_HOME................/soft/ora11g/11202 
Listenerportnumber................1521 
DatabaseSID................test 
Emailaddressfornotifications............... 
OutgoingMail(SMTP)serverfornotifications............... 
----------------------------------------------------------------- 
---------------------------------------------------------------------- 
WARNING:Whilerepositoryisdroppedthedatabasewillbeputinquiescemode. 
---------------------------------------------------------------------- 
Doyouwishtocontinue?[yes(Y)/no(N)]:Y 
Nov23,20123:52:33PMoracle.sysman.emcp.EMConfigperform 
INFO:Thisoperationisbeingloggedat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.log. 
Nov23,20123:52:35PMoracle.sysman.emcp.util.DBControlUtilstopOMS 
INFO:StoppingDatabaseControl(thismaytakeawhile)... 
Nov23,20123:52:56PMoracle.sysman.emcp.EMReposConfiginvoke 
INFO:DroppingtheEMrepository(thismaytakeawhile)... 
Nov23,20123:54:56PMoracle.sysman.emcp.EMReposConfiginvoke 
INFO:Repositorysuccessfullydropped 
Nov23,20123:54:57PMoracle.sysman.emcp.EMReposConfigcreateRepository 
INFO:CreatingtheEMrepository(thismaytakeawhile)... 
Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfigcreateRepository 
WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated 
ORA-06512:at"SYSMAN.EMD_LOADER",line4986 
ORA-06512:atline1 
Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfiginvoke 
SEVERE:Errorcreatingtherepository 
Nov23,20123:57:30PMoracle.sysman.emcp.EMReposConfiginvoke 
INFO:Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_repos_create_<date>.logformoredetails. 
Nov23,20123:57:30PMoracle.sysman.emcp.EMConfigperform 
SEVERE:Errorcreatingtherepository 
Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails. 
Couldnotcompletetheconfiguration.Refertothelogfileat/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.logformoredetails.

标签:

相关文章

热门资讯

玄元剑仙肉身有什么用 玄元剑仙肉身境界等级划分
玄元剑仙肉身有什么用 玄元剑仙肉身境界等级划分 2019-06-21
男生常说24816是什么意思?女生说13579是什么意思?
男生常说24816是什么意思?女生说13579是什么意思? 2019-09-17
配置IIS网站web服务器的安全策略配置解决方案
配置IIS网站web服务器的安全策略配置解决方案 2019-05-23
Nginx服务器究竟是怎么执行PHP项目
Nginx服务器究竟是怎么执行PHP项目 2019-05-24
运维必须知道的关于云服务器的十个问题
运维必须知道的关于云服务器的十个问题 2019-05-24
返回顶部