Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. p_acq_06: "Oracle error: fetch z78 ORA-00600: internal error code ..."

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • p_acq_06 skips records
      • p_acq_06: "Oracle error: update_cursor z13 ... invalid table name"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved