ORA-00001: unique constraint (SYSMAN.PARAMETERS_PRIMARY_KEY) violated

Oracle Database 11.2.0.3 on Redhat linux 5

I wanted to test something withing dbconsole, but my test database dbconsole was not properly configured I guess.

So decided to drop and recreate.
Dropped using "<ORACLE_HOME>/bin/emca -deconfig dbcontrol db -repos drop"

Tried to recreate using "<ORACLE_HOME>/bin/emca -config dbcontrol db -repos create" but it failed with below errors:

WARNING: ORA-00001: unique constraint (SYSMAN.PARAMETERS_PRIMARY_KEY) violated
ORA-06512: at "SYSMAN.EMD_LOADER", line 4986
ORA-06512: at line 1

Jan 9, 2012 5:44:30 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository

Below is the test case:

1. Checked the violating constraint and existing rows before dropping the repository again.

select owner, table_name from user_constraints where constraint_name like '%PARAMETERS_PRIMARY_KEY%'

OWNER    TABLE_NAME
------------------------------------
SYSMAN  MGMT_PARAMETERS


SQL> select count(*) from sysman.mgmt_parameters;

  COUNT(*)
----------
         3

2. Dropped repository to check whether this table gets dropped or not.

emca -deconfig dbcontrol db -repos drop
INFO: Repository successfully dropped

3. Check sysman.mgmt_parameters

select count(*) from sysman.mgmt_parameters
                            *
ERROR at line 1:
ORA-00942: table or view does not exist

4.  Creating dbconsole using "emca -config dbcontrol db -repos create"

STARTED EMCA at Jan 9, 2012 5:41:37 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: RD11852
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/product/11.2.0.3 ]:
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 ................ /oracle/product/11.2.0.3

Local hostname ................ ****************
Listener ORACLE_HOME ................ /oracle/product/11.2.0.3
Listener port number ................ 1521
Database SID ................ RD11852
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jan 9, 2012 5:42:04 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/cfgtoollogs/emca/RD11852/emca_2012_01_09_17_41_36.log.
Jan 9, 2012 5:42:06 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...

Jan 9, 2012 5:44: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

Jan 9, 2012 5:44:30 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Jan 9, 2012 5:44:30 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /oracle/cfgtoollogs/emca/RD11852/emca_repos_create_<date>.log for more details.
Jan 9, 2012 5:44:30 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at /oracle/cfgtoollogs/emca/RD11852/emca_2012_01_09_17_41_36.log for more details.
Could not complete the configuration. Refer to the log file at /oracle/cfgtoollogs/emca/RD11852/emca_2012_01_09_17_41_36.log for more details.

 I have read MOS notes with similar error but while db upgrade from 10g to 11g and they say we can ignore these errors. But here I am trying to create dbconsole and it does not let me ignore it. I guess I will have to create SR.

I will post the solution once it is available.

BTW below are the rows in sysman.mgmt_parameters table:

SQL> select parameter_name, parameter_value from sysman.mgmt_parameters;

PARAMETER_NAME            PARAMETER_VALUE
------------------------- -------------------------
EST_ANALYZE               OFF
TARGET_POLICY_ENABLED     N
load_interval             300