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