oracle 11g em重建報唯一約束錯誤解決方法建站知識
導讀:1建站知識今天在手工配置Oracle11g的EM時總是報如下錯誤,也沒有找到解決辦法,以下是我的解決過程,希望可以幫助你們營銷型網站建設網站建設。
今天在手工配置Oracle11g的EM時總是報如下錯誤: WARNING:ORA-00001:uniqueconstraint(SYSMAN.PARAMETERS_PRIMARY_KEY)violated ORA-06512:at"SYSMAN.EMD_LOADER",line4986 ORA-06512:atline1 以Metalink上也沒有找到解決辦法,以下是我的解決過程: 1、數據庫版本網站seo優化診斷工具 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.EMConfiseo網站優化培訓gperform INFO:Thisoperationisbeinglogge網站建設制作dat/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.相關營銷型網站建設網站建設。
聲明: 本文由我的SEOUC技術文章主頁發布于:2023-05-23 ,文章oracle 11g em重建報唯一約束錯誤解決方法建站知識主要講述解決方法,錯誤,oracle 11g em重建報唯一約束錯誤網站建設源碼以及服務器配置搭建相關技術文章。轉載請保留鏈接: http://www.bifwcx.com/article/web_5629.html