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

    Web OPAC searching doesn't work: "Oracle error: io_z63_write"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    When you do a search in the web OPAC page the search doesn't register with Aleph, and no results are returned. I checked the www log files, and see a number of error messages, of which this seems to be the important one:

    Oracle error: io_z63_write
    ORA-38301: can not perform DDL/DML over objects in Recycle Bin

    I checked the Knowledge base, and saw KB 16384-913 about using an sql command to check the status of the recycle bin. I went ahead and tried the suggested sql command: purge recyclebin;
    (I did this for abc01).

    That seemed to do the trick, and web OPAC searches appear to be working again. So it may well have been that the recycle bin did just get full. But would someone at Ex Libris please confirm whether that was all that was going on; and particularly, is our recycle bin setting set correctly?

    We thought this was fixed, but it was fixed for only about one minute, and then the problem returned. So the web OPAC is still not functional.

    Resolution:
    The Recycle Bin was turned on, and that is okay, but not standard. If you don't have processes in place to clear it from time to time, it is better to leave it off. So, I turned it off for now.

    I thought that would resolve the problem, but I also needed to do clear_vir01.

    Once that ran, all now seemed to be working, but about 20 minutes later, the following message started appearing:

    Oracle error: io_z63_write
    ORA-00600: internal error code, arguments: [kcbnew_3], [0], [1], [3137
    WRITE ERROR I24T3V65LI8S8SH3KRND8A8YUTECFJAYHXQ5A6SYHYJ381ED2J

    This was ultimately corrected by: (1) restarting Aleph / Oracle and (2) doing util a/17/1 for the vir01 z63.

    The relevant recycle bin is the *vir01* recycle bin (that's where the z63 and z110 reside) not the abc01. It may be that that will need to be purged sometime, but the "ALTER SYSTEM SET recyclebin = OFF scope=BOTH" described in KB 16384-913 should make this unnecessary.

    • Article last edited: 10/8/2013