Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ue_01_z0102 too slow; ctx_sync_error and Oracle Text error

    • Article Type: General
    • Product: Aleph
    • Product Version: 18, 19, 20, 21, 22, 23



    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


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



    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