OEM Cloud Control Upgrade Problem

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 5 Jun 2018 16:28:20 -0500
Message-ID: <CAJvnOJYYS23iKdQCYSVsxaW=uUmHjMPv7wqJqX=GNo9ms2Gv_w_at_mail.gmail.com>

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.'

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 05 2018 - 23:28:20 CEST