ue_01_z0102 too slow; ctx_sync_error and Oracle Text error

Description

In xxx01/scratch/ue_01_z0102 log file or when saving a record using util f/1/13 the following error appears:

Oracle error: ctx_sync_error
ORA-20000: Oracle Text error:
DRG-10313: logging has already been star

or

Oracle error: ctx_sync_error
ORA-20000: Oracle Text error:
DRG-11134: The file /exlibris/app/oracle

 

Resolution:

Problem is the xxx01 table z91 for storing ADAM index objects.

If ADAM is not in use, the z91 should be dropped in the XXX01 library using the following SQL:
s+ XXX01
drop table z91;

If you do use ADAM
1. create the table again using util a/17/2 and util a/17/3.
2. Re-run service "Update Full Text Index (manage-91)" outside your working hours

Additional Information

Related articles:

ctx_sync_error, ORA-20000 and DRG-10502 

util f/1/13: Oracle error: update_cursor z91; ctx_sync_error

• Article last edited: 18-April-2016