ORA-00600: [qkaffsindex5] During SQL Execution
(Doc ID 2197417.1)
Last updated on APRIL 06, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
You are attempting to execute SQL performing a DELETE or INSERT statements and they all fail with the following error:
ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], []
The stack trace will be similar to the following:
skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv <- kgeasnmierr <- qkaffsindex <- qkatab <- qkajoi <- qkaqkn <- qkadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksSetBindType <- kksfbc <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- libc_start_main <- start
You have applied the patch for Bug:21285458 or even tried some of the workarounds such as:
alter session SET "_fix_control"='9929609:OFF';
alter session set _replace_virtual_columns=false;
alter session set _disable_function_based_index=true;
but it continues to fail with the same error.
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 |