源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

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

  • 时间:2021-09-22 21:28 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:oracle 11g em重建报唯一约束错误解决方法
今天在手工配置Oracle11g的EM时总是报如下错误: WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated ORA-06512:at"SYSMAN.EMD_LOADER",line4986 ORA-06512:atline1 以Metalink上也没有找到解决办法,以下是我的解决过程: [b]1、数据库版本[/b] 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 [b]2、配置EM时的步骤[/b] [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.
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部