欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2023-12-03 17:54:28
今天在手工配置oracle11g的em时总是报如下错误: warning:ora-00001:uniqueconstraint(sysman.parameters_prim...
今天在手工配置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.