ORA-600 [17147] and [17114] on Select using Stemmer

(Doc ID 1327521.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.2.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

During the execution of a select like:

select id_stud as cvtxt_id_stud
from cvtext
where (CONTAINS(cvtext.TESTO_FULL,'$ACQUA',1)>0)

The following error occurs:

ORA-00600: internal error code, arguments: [17147], [0x11073FB48], [], [], [], [], [], [], [], [], [], []

The stack is similar to:

kgherror <- kghfrmrg <- kghfre <- kghsfx <- kghfrempty <- kghgex <- kghalf <- kcikghalf2 <- drumcma <- drwasxexp <- drwasexp <- drwaexp <- drpnwl <- IPRA <- drpnormalize <- drpzparse <- drexoprscb <- rpiswu2 <- kci_rpiswu2 <- drexoprs <- drexocqstats <- drexofcost <- spefcpfa ...........................

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