CJQ0 Hitting ORA-600 [504], [0X06000BC90], [4], [0], [active service list] in RAC Environment (Doc ID 1071534.1)

Last updated on MAY 27, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

In instances of a RAC database CJQ0 process is hitting:
ORA-00600: internal error code, arguments: [504], [0x.....], [4], [0], [active service list], [0], [0], [0x000000000]
and is restarting.

The alert log file reports:
ORA-00600: internal error code, arguments: [504], [0x.....], [4], [0],
[active service list], [0], [0], [0x000000000]
followed by:
CJQ0 started with pid=..., OS id=....

Call stack trace from ORA-600 trace file contains:
ksedst ksedmp ksfdmp kgeriv kgesiv ksesic7 ksl_level_check kslgetsl kswssvid jsksIsServiceActive jsksCheckForBCast jsksSendBCastMsg jskqWindowJobOps jskqLocalExecuteWindow jscrgq_refresh_generic_q jscrs_select0 ...

The presence of jsksCheckForBCast is relevant here.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms