My Oracle Support Banner

Missing Oracle Text Supplied Knowledge Base After Database 12c Release 1 Installation (Doc ID 1910616.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Text - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Missing the supplied Text Knowledge Base files, English and French.
When trying to create a text index with themes enabled following errors are thrown:

SQL> begin
ctx_ddl.create_preference('mylex', 'BASIC_LEXER');
ctx_ddl.set_attribute ( 'mylex', 'index_themes', 'YES');
end;
/

PL/SQL procedure successfully completed.

SQL> create table t (a varchar2(40));

Table created.

SQL> insert into t values ('The lazy fox jumps over the box');

1 row created.

SQL> create index tx on t ( a ) indextype is ctxsys.context
parameters ( 'LEXER mylex' );
create index tx on t ( a ) 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-11446: supplied knowledge base file
/u1/app/oracle/product/12101/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

 

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


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.