ORA-600:[kcbzwfcro_2] Reported in Alert.log
(Doc ID 2085507.1)
Last updated on AUGUST 25, 2023
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.2.0.4 and later
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 Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Alert log reports errs like:
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_p029_2980.trc:
ORA-10388: parallel query server interrupt (failure)
ORA-00600: internal error code, arguments: [kcbzwfcro_2], [187984], [1], [32768], [0], [], [], [], [], [], [], []
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_p029_2980.trc:
ORA-10388: parallel query server interrupt (failure)
ORA-00600: internal error code, arguments: [kcbzwfcro_2], [187984], [1], [32768], [0], [], [], [], [], [], [], []
ORA-10388: parallel query server interrupt (failure)
ORA-00600: internal error code, arguments: [kcbzwfcro_2], [187984], [1], [32768], [0], [], [], [], [], [], [], []
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_p029_2980.trc:
ORA-10388: parallel query server interrupt (failure)
ORA-00600: internal error code, arguments: [kcbzwfcro_2], [187984], [1], [32768], [0], [], [], [], [], [], [], []
The trace file contains no current sql and a call stack with functions like:
... ksucin krr_thread_read krr_read_buffer krr_parse_redo kcra_scan_redo kcra_dump_redo kcra_dump_redo_internal kcbzwfcro kcbgcur ktbgcur
kturGetCurPinForUndo kdiulk kcoubk ktprundo_intra ktprits ktprmai kxfprdp opirip opidrv sou2o opimai_real ssthrdmain main
At the beginning of the trace file also lines are reported like:
========= Dump for incident 231769 (ORA 600 [kcbzwfcro_2]) ========
----- Beginning of Customized Incident Dump(s) -----
Potentially stale force-CR-override buffer found before OBJD MISMATCH check.
This issue should be investigated by both cache fusion and space layer.
BH (0x57f89cc98) file#: 7 rdba: 0x0006048b (1024/394379) class: 1 ba: 0x57c3ea000
set: 48 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,5
dbwrid: 1 obj: 187984 objn: 187984 tsn: 7 afn: 7 hint: f
hash: [0xc12258060,0x2e7778a30] lru: [0x8f79d14a8,0x6f787e608]
ckptq: [NULL] fileq: [NULL] objq: [0x6af974790,0x3e7a932f0] objaq: [0x9ef72d000,0x977872820]
st: XCURRENT md: NULL fpin: 'kdgwh05: kdglfe' tch: 4 le: 0x7b7e39ef0
flags: block_written_once redo_since_read remote_transfered
force_cr_override
...
----- Beginning of Customized Incident Dump(s) -----
Potentially stale force-CR-override buffer found before OBJD MISMATCH check.
This issue should be investigated by both cache fusion and space layer.
BH (0x57f89cc98) file#: 7 rdba: 0x0006048b (1024/394379) class: 1 ba: 0x57c3ea000
set: 48 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,5
dbwrid: 1 obj: 187984 objn: 187984 tsn: 7 afn: 7 hint: f
hash: [0xc12258060,0x2e7778a30] lru: [0x8f79d14a8,0x6f787e608]
ckptq: [NULL] fileq: [NULL] objq: [0x6af974790,0x3e7a932f0] objaq: [0x9ef72d000,0x977872820]
st: XCURRENT md: NULL fpin: 'kdgwh05: kdglfe' tch: 4 le: 0x7b7e39ef0
flags: block_written_once redo_since_read remote_transfered
force_cr_override
...
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 |