I was working on an upgrade to OEM Cloud control from version 12.1.0.4 to
version 13.2. Database version 12.1.0.2. All on windows x64.
During the upgrade process, I received this error while it was upgrading
the repository:
ORA-00001 unique constraint (SYS.i_WRI$_OPSTAT_HH_OBJ_ICOL_ST) VIOLATED
ORA-06512 at "SYS.DBMS_STATS", line 35143
ORA-06512 at "SYSMAN.EM_USER_MODEL", line 4665
ORA-06512: at line 3
File
E:\app\prac;e\OMS13\sysman\admin\emdrep\sql\core\13.1.0\user_model\user_model_post_creation.sql
statement: BEGIN
EXECUTE IMMEDIATE 'ALTER TABLE EM_STAT_TARGETS_E NOLOGGIN';
EM_USER_MODEL_POPULATE_SET_TARGETS();
COMMIT;
END;
I found a similar error on MOS, and tried deleting all the stats history,
but that did not fix the problem. I do have a case open with MOS, but I
know we have a lot of people here who have worked with cloud control.
Does anyone know the fix to this error?
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'