My Oracle Support Banner

ORA-00600 [kcbzwb_4] - OEM: update MGMT_AVAILABILITY_MARKER by sysman (Doc ID 467521.1)

Last updated on OCTOBER 02, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.4 to 10.2.0.3 [Release 10.1 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

ORA-600 [kcbzwb_4] signalled in alert.log  from an OEM update query by SYSMAN -
 UPDATE MGMT_AVAILABILITY_MARKER SET MARKER_TIMESTAMP = :B1 WHERE
MARKER_TIMESTAMP <= :B1 AND TARGET_GUID IN (SELECT /*+ INDEX(t
mgmt_targets_idx_02) */ T.TARGET_GUID FROM MGMT_TARGETS T WHERE T.EMD_URL = :B2  AND T.REP_SIDE_AVAIL = 0 AND NOT EXISTS (SELECT 1 FROM MGMT_BLACKOUT_WINDOWS BW WHERE BW.TARGET_GUID = T.TARGET_GUID AND BW.START_TIME <= :B1 AND (BW.STATUS NOT IN (:B4 , :B3 ) ) ) AND NOT EXISTS (SELECT 1 FROM MGMT_GENSVC_AVAIL=CONFIG BCNAV WHERE BCNAV.TARGET_GUID = T.TARGET_GUID) )
.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.