Local Propagation - Ora-00600 Kwqbdrcp101 Occurs After Instance Restart With Queue Spill
(Doc ID 1403505.1)
Last updated on AUGUST 30, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Streams Local propagation or having a propagation job sending LCRs from a Streams Capture queue to
another separate queue on the same database where an Apply process will consume these LCRs
Queue spill is present on the Cpature queue. This may be due to a high workload of LCRs for the Capture
to process and the Apply process may have been stopped.
When instance the Oracle instance is stopped then restarted and following this action, the propagation job
reports errors of form :
kwqpbdeq: Error 600 occured when deleting acked messagesfor queue:106939 destination:"<STRMADMIN_USER>"."<QUEUE>"@AQ$_LOCAL
ORA-00600: internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], [], [], [], [], []
Functions at the top of the stack in the associated incident trace file :
...
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 |