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

    p_acq_06: "Oracle error: fetch z78 ORA-00600: internal error code ..."

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    p_acq_06 (for serials) is getting the following errors (as seen in the $alephe_scratch/p_acq_06 log):

    Oracle error: fetch z78
    ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [],

    Oracle error: update_cursor z78
    ORA-03113: end-of-file on communication channel

    Oracle error: fetch z68
    ORA-03114: not connected to ORACLE

    ***************************************************
    * No ORACLE connection - process is terminated... *
    ***************************************************

    I/O error : file '/exlibris/aleph/a18_1/tmp/usm501224237'
    error code: 4/6 (ANS85), pc=0, call=1, seg=0
    146 No current record defined for sequential read

    mv: cannot stat `/exlibris/aleph/u18_1/uma50/scratch/p_acq_06.2': No such file or directory

    Resolution:
    We rebuilt the Oracle index for the z78 (using util a/17/3) and we no longer get the error. I have run p_acq_06 (with Update = N) successfully. (See the $alephe_scratch/abc50_p_acq_06.0703b log.)

    In the course of doing this the 000962407-00020-012 z78 order claim record (for "Vol. 89", November 2007) was deleted. I'm pretty sure that this volume was received and that this claim is no longer needed.

    See also KB 16384-5874.


    • Article last edited: 10/8/2013