ORA-600 [17147] and [17114] on Select using Stemmer (Doc ID 1327521.1)

Last updated on MARCH 11, 2019

Applies to:

Symptoms

During the execution of a select like:

select id as my_id from TextIndexedTable
  where (CONTAINS(TextIndexedTable.TextCol,'$STEMME',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 ...........................

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.