rdbms 19.3 crashes on commit when Text index has parameter sync(on commit)
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