广

oracle数据库

  • MYSQL
  • MSSQL
  • Redis
  • MongoDB
  • oracle数据库
  • 数据管理

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

    2018-05-07 10:24:35 次阅读 稿源:互联网
    广告
    全网推广平台,软文发布
    今天在手工配置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.0Production

    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.

    一起学吧部分文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与一起学吧进行文章共享合作。

    广告
    广告
    广告
    广告