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 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_<date>.log for more details.

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.

1 2 下一頁