ORA-00600 [ktecgetsh-inc], ORA-00600 [opiexe0] In a RAC Environment After ALTER TABLE SHRINK SPACE or ALTER INDEX SHRINK SPACE (Doc ID 2297992.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Linux x86-64

Symptoms

Alert log shows below errors(in a 6 node Real Application Clusters environment):

ORA-00600: internal error code, arguments: [ktecgetsh-inc], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [opiexe0], [10632], [], [], [], [], [], [], [], [], [], []

The current SQL contains DML (INSERT) and the call stack contains below functions

ktecgetsh <- ktecgshx <- ktspisc <- ktspgsp_main2 <- kdtgsp <- kdtgsph <- kdtgrs
<- kdtInsRow <- qerltcNoKdtBufferedInsRowCBK <- qerltcSingleRowLoad <- qerltcFetch

The table involved in the failing INSERT operation is a partitioned table.

Changes

Issue is visible only for one day after de-fragmentation using ALTER TABLE SHRINK SPACE or ALTER INDEX SHRINK SPACE.

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