Oracle 11g重建EM时报唯一约束错误

今天在手工配置Oracle 11g的EM时总是报如下错误：WARNING: ORA-00001: unique constraint （SYSMAN.PARAMETERS_PRIMARY_KEY） violated
ORA-06512: at "SYSMAN.EMD_LOADER", line 4986
ORA-06512: at line 1以Metalink上也没有找到解决办法，以下是我的解决过程：1、数据库版本SQL> select * from v$version;BANNER------------------------------------------------------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 – Production2、配置EM时的步骤[oracle@Core-Nbu-Rollback ~]$ emca -config dbcontrol db -repos recreateSTARTED EMCA at Nov 23, 2012 3:52:08 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright （c） 2003, 2011, Oracle. All rights reserved. Enter the following information:Database SID: testDatabase Control is already configured for the database testYou have chosen to configure Database Control for managing the database testThis will remove the existing configuration and the default settings and perform. a fresh configuration----------------------------------------------------------------------WARNING : While repository is dropped the database will be put in quiesce mode.----------------------------------------------------------------------Do you wish to continue？ [yes（Y）/no（N）]: YListener ORACLE_HOME [ /soft/ora11g/11202 ]:Password for SYS user:Password for DBSNMP user:Password for SYSMAN user:Email address for notifications （optional）:Outgoing Mail （SMTP） server for notifications （optional）:----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /soft/ora11g/11202 Local hostname ................ Core-Nbu-RollbackListener ORACLE_HOME ................ /soft/ora11g/11202Listener port number ................ 1521Database SID ................ testEmail address for notifications ...............Outgoing Mail （SMTP） server for notifications ............... ---------------------------------------------------------------------------------------------------------------------------------------WARNING : While repository is dropped the database will be put in quiesce mode.----------------------------------------------------------------------Do you wish to continue？ [yes（Y）/no（N）]: YNov 23, 2012 3:52:33 PM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.log.Nov 23, 2012 3:52:35 PM oracle.sysman.emcp.util.DBControlUtil stopOMSINFO: Stopping Database Control （this may take a while） ...Nov 23, 2012 3:52:56 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Dropping the EM repository （this may take a while） ...Nov 23, 2012 3:54:56 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully droppedNov 23, 2012 3:54:57 PM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository （this may take a while） ...Nov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMReposConfig createRepositoryWARNING: ORA-00001: unique constraint （SYSMAN.PARAMETERS_PRIMARY_KEY） violatedORA-06512: at "SYSMAN.EMD_LOADER", line 4986ORA-06512: at line 1 Nov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMReposConfig invokeSEVERE: Error creating the repositoryNov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Refer to the log file at /soft/ora11g/cfgtoollogs/emca/test/emca_repos_create_<date>.log for more details.Nov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMConfig performSEVERE: Error creating the repositoryRefer to the log file at/soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.logfor more details.Could not complete the configuration. Refer to the log file at /soft/ora11g/cfgtoollogs/emca/test/emca_2012_11_23_15_52_07.log for more details.

Oracle分布事务中最先提交分布式的3个阶段在Linux下根据inode删除使用rm删除不了的文件相关资讯 Oracle 11g Oracle 11g重建EM Oracle EM重建

Oracle 11g导入到10g引起的错误（11/16/2015 10:55:27）
Oracle 11g 导库导不出空表问题（08/19/2015 19:55:58）
Oracle 11g统计信息收集--多列统计（07/24/2015 10:32:39）

Oracle 11gClone安装方法（08/24/2015 20:25:41）
Oracle 11g中和SQL TUNING相关的新（08/12/2015 11:22:52）
Oracle 11g数据泵详解（07/08/2015 08:29:51）

本文评论查看全部评论（0）