ORA-00600: [qkaffsindex5] During SQL Execution (Doc ID 2197417.1)

Last updated on OCTOBER 26, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information 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.

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