服务器之家:专注于服务器技术及软件下载分享
分类导航

Mysql|Sql Server|Oracle|Redis|MongoDB|PostgreSQL|Sqlite|DB2|mariadb|Access|数据库技术|

服务器之家 - 数据库 - Oracle - oracle 11g em重建报唯一约束错误解决方法

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

2019-11-15 15:41oracle教程网 Oracle

今天在手工配置Oracle11g的EM时总是报如下错误,也没有找到解决办法,以下是我的解决过程,希望可以帮助你们

今天在手工配置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.

延伸 · 阅读

精彩推荐