Missing preferences BASIC_LEXER, BASIC_WORDLIST,BASIC_STORAGE in oracle Text Installation on 12c. (Doc ID 2272369.1)

Last updated on MAY 31, 2017

Applies to:

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

Symptoms

On : 12.1.0.2 version, Install and upgrade issues

Missing data in Oracle text installation.

Missing data in Oracle text installation. we installed oracle text on 12c databases, we expected 20 records for the query "select * from ctxsys.ctx_preferences where pre_owner = ‘CTXSYS’ order by pre_owner, pre_name;". But we missed the below 3 records when compared to other database.

Missed records:

PRE_OWNER PRE_NAME PRE_CLASS PRE_OBJECT
-------------------- ------------------------------ ------------------------------ ------------------------------
CTXSYS DEFAULT_LEXER LEXER BASIC_LEXER
CTXSYS DEFAULT_WORDLIST WORDLIST BASIC_WORDLIST
CTXSYS DEFAULT_STORAGE STORAGE BASIC_STORAGE


 

ERROR
-----------------------
Missing preferences in Oracle text installation.

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