当前位置: 移动技术网 > IT编程>数据库>Oracle > oracle 11g em重建报唯一约束错误解决方法

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

2017年12月12日  | 移动技术网IT编程  | 我要评论

废铜回收价格,2013驾驶员考试科目一,无龄的养生智慧

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

如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复

相关文章:

验证码:
移动技术网