THE FND_LOBS_CTX INDEX IS MISSING FROM THE DATABASE

(Doc ID 2363383.1)

Last updated on FEBRUARY 20, 2018

Applies to:

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

Symptoms

Oracle database 12.1.0.2.0 => Production

User unable to make file attachments in oracle Form. its failing with

java.sql.SQLException: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexInsert
ORA-20000: Oracle Text error:
DRG-10607: index meta data is not ready yet for queuing DML
ORA-00068: invalid value 1500000000 for parameter _kgl_large_heap_assert_threshold, must be between 0 and 0
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 756

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