My Oracle Support Banner

Encountering Errors ORA-20000, DRG-11422, DRG-00100, DRG-11432 when Searching or Creating Text Index with Themes enabled (Doc ID 742455.1)

Last updated on MARCH 14, 2013

Applies to:

Oracle Text - Version 9.2.0.2 to 11.1.0.6 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***

Symptoms

-- Problem Statement:
When trying to search documents through a Text index the user gets the following errors when NLS_LANGUAGE is not AMERICAN or FRENCH:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-00100: internal error, arguments : [52100],[drxs.c],[557],[gxtopen],[1]
DRG-11432: file error while accessing knowledge base


Similar errors are seen when you create a Text index with index_themes enabled and you are running the index build from a session where NLS_LANGUAGE is not AMERICAN or FRENCH:

create index tx on t(b) indextype is ctxsys.context
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-00100: internal error, arguments : [52100],[drxa.c],[356],[gxtopen],[1]
DRG-00100: internal error, arguments : [52100],[gxt.c],[185],[gxl err],[7]
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364


-- Steps To Reproduce:

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
Cause
Solution
 Workaround
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.