oracle 11g em重建报唯一约束错误解决措施
发布时间：2021-11-28 21:50:04 所属栏目：教程 来源：互联网
导读：今天在手工配置Oracle11g的EM时总是报如下错误： WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated ORA-06512:atSYSMAN.EMD_LOADER,line4986 ORA-06512:atline1 以Metalink上也没有找到解决办法，以下是我的解决过程： 1、数据库
|
今天在手工配置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/  （编辑：宁德站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
