EM: Oracle11g: EM: Oracle11g WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated ORA-06512:at”SYSMAN.EMD_LOADER”,line4986 ORA-06512:atline1 No solution was found on Metalink. The following is my solution process:
1. Database version 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. Steps for configuring 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.