RE: OEM Cloud Control Upgrade Problem
From: Pete Sharman <peter.sharman_at_westnet.com.au>
Date: Wed, 6 Jun 2018 07:43:08 +1000
Message-ID: <084401d3fd16$3982af10$ac880d30$_at_westnet.com.au>
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.
Date: Wed, 6 Jun 2018 07:43:08 +1000
Message-ID: <084401d3fd16$3982af10$ac880d30$_at_westnet.com.au>
Haven’t seen in personally, Andrew, but how did you purge the stats? Other occurrences of this error seem to have been fixed by:
SQL> exec DBMS_STATS.PURGE_STATS(DBMS_STATS.PURGE_ALL);
Is that what you used?
Pete
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Andrew Kerber
Sent: Wednesday, June 6, 2018 07:28 AM
To: ORACLE-L <oracle-l_at_freelists.org>
Subject: OEM Cloud Control Upgrade Problem
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-lReceived on Tue Jun 05 2018 - 23:43:08 CEST