My Oracle Support Banner

ORA-00600 [504], [object Queue Header Operation] [checkpoint Queue Latch] (Doc ID 2725897.1)

Last updated on MARCH 08, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Getting this internal error on standby database.

Mon Oct 26 09:12:51 2020

ORA-00600: internal error code, arguments: [504], [0x1DA159098], [34], [5], [object queue header operation], [224], [0x1DBC44230], [checkpoint queue latch], [], [], [], []

----- Beginning of Customized Incident Dump(s) -----
*** LATCH HIERARCHY ERROR ***
An attempt to get the 'object queue header operation' latch (child #275) at level 5 (address = 0x1da2854c0)
from location 'kcbo.h LINE:1051 ID:kcbo_unlink_q' (also see call stack below)
conflicts with the following held latch(es):
 Level 5: 'checkpoint queue latch' (child #9) (address = 0x1dbc44138)
  gotten from location 'kcbk.h LINE:2546 ID:kcbzre1: unlink recovery buffers'


*** 2020-10-26 09:12:48.982
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)

----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.


ksl_level_check
ksl_get_shared_latch
kcbo_unlink_q1
kcbzrefb
kcbzre1
krdssod
kcbzre1()

Changes

 

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