Oracle Text (MOSC)

MOSC Banner

rdbms 19.3 crashes on commit when Text index has parameter sync(on commit)

edited Apr 2, 2020 5:00AM in Oracle Text (MOSC) 2 commentsAnswered

Hi,

We have rebuilt a 12.2 database as 19.3 on a new server, and impdp to move data.

on 19.3

We have a text index like:

create index claim_document_n01 on claim_document(search_empl_full_nm) indextype is ctxsys.context

  parameters ('datastore name_ds section group name_sg wordlist name_wl sync (on commit)');

It's table is updated in a package amongst other tables.  The package completes successfully.

On: commit

the database stops.

nothing in Alert.log ASM log complains of communication loss with database.

one work around is to drop and recreated index as without sync (on commit):

create index claim_document_n01 on claim_document(search_empl_full_nm) indextype is ctxsys.context

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center