• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    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上也没有找到解决办法,以下是我的解决过程:

    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/emca_2012_11_23_15_52_07.logformoredetails.
    您可能感兴趣的文章:
    • 关于sql脚本导入Oracle时重复生成check约束的问题解决
    • Oracle数据库的字段约束创建和维护示例
    • 在Oracle数据库中添加外键约束的方法详解
    • oracle删除主键查看主键约束及创建联合主键
    • Oracle约束管理脚本
    • Oracle如何给数据库添加约束过程解析
    上一篇:Oracle用户密码含有特殊字符导致无法登陆解决方法
    下一篇:linux下oracle设置开机自启动实现方法
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

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