今天在手工配置Oracle 11g的EM时总是报如下错误：WARNING: ORA-00001: unique constraint (SYSMAN.PARAMETERS_PRIMARY_KEY) viol
今天在手工配置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 Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 – Production
2、 配置EM时的步骤
[oracle@Core-Nbu-Rollback ~]$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Nov 23, 2012 3:52:08 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: test
Database Control is already configured for the database test
You have chosen to configure Database Control for managing the database test
This 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)]: Y
Listener 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-Rollback
Listener ORACLE_HOME ................ /soft/ora11g/11202
Listener port number ................ 1521
Database SID ................ test
Email 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)]: Y
Nov 23, 2012 3:52:33 PM oracle.sysman.emcp.EMConfig perform
INFO: 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 stopOMS
INFO: Stopping Database Control (this may take a while) ...
Nov 23, 2012 3:52:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 23, 2012 3:54:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Nov 23, 2012 3:54:57 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMReposConfig createRepository
WARNING: ORA-00001: unique constraint (SYSMAN.PARAMETERS_PRIMARY_KEY) violated
ORA-06512: at "SYSMAN.EMD_LOADER", line 4986
ORA-06512: at line 1
Nov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Nov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /soft/ora11g/cfgtoollogs/emca/test/emca_repos_create_
Nov 23, 2012 3:57:30 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer 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.
