今天在手工配置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.
oracle 11g em重建报唯一约束错误解决方法
2019-11-15 15:41oracle教程网 Oracle
今天在手工配置Oracle11g的EM时总是报如下错误,也没有找到解决办法,以下是我的解决过程,希望可以帮助你们
延伸 · 阅读
- 2021-12-20linux系统下oracle11gR2静默安装的经验分享
- 2021-11-12oracle11g卸载完整图文教程
- 2021-09-28教你使用PLSQLDeveloper14连接Oracle11g的详细过程
- 2021-08-08Oracle11g R2 安装教程完整版
- 2021-08-08Oracle11g r2 卸载干净重装的详细教程(亲测有效已重
- 2021-06-30Docker安装Oracle_11g的方法
- Oracle
Oracle数据库由dataguard备库引起的log file sync等待问题
这篇文章主要介绍了Oracle数据库由dataguard备库引起的log file sync等待,本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋...
- Oracle
oracle 动态AdvStringGrid完美示例 (AdvStringGrid使用技巧/Cells)
本方法实现用常量和常量数组完美创建和控制动态TAdvStringGrid。 ...
- Oracle
Oracle查看表结构命令详解
这篇文章主要介绍了Oracle查看表结构命令详解的相关资料,需要的朋友可以参考下 ...
- Oracle
oracle中利用关键字rownum查询前20名员工信息及rownum用法
这篇文章主要介绍了oracle中利用关键字rownum查询前20名员工信息,本文通过代码给大家简单介绍了ORACLE 中ROWNUM用法,非常不错,具有一定的参考借鉴价值,需...
- Oracle
oracle使用instr或like方法判断是否包含字符串
使用contains谓词有个条件,那就是列要建立索引,本节主要介绍了oracle使用instr或like方法判断是否包含字符串,需要的朋友可以参考下 ...
- Oracle
oracle 优化的一点体会
oracle 优化的一点体会大家可以参考下,提升运行效率。 ...
- Oracle
[Oracle] dbms_metadata.get_ddl 的使用方法总结
以下是对Oracle中dbms_metadata.get_ddl的用法进行了详细的分析介绍,需要的朋友参考下 ...
- Oracle
Linux中Oracle数据库备份
在Linux中Oracle数据库备份的方法有很多,就像mysql一样可以使用不同方法进行备份oracle数据库 ...