ABC01 "Library not accessible"; p_manage_102: "Oracle error: fetch z00"

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
When in the GUI Cataloging module, connected to ABC01, we get the message "Library not accessible".

Resolution:
We see the following in the ./abc01/scratch/p_manage_102_a_1.log:
...
...
33034 READING DOC 000033033 AT 16:42:09
34035 READING DOC 000034034 AT 16:43:16

Oracle error: fetch z00
ORA-03113: end-of-file on communication channel
Process ID: 28927
Sess
***************************************************
* No ORACLE connection - process is terminated... *
***************************************************
Mon Apr 30 16:44:08 EDT 2012

The cause of this error is unclear. It may be connected to the fact that delete flag was set to "0". {The run of p_manage_102 for the first authority library should always be done with "1" (Delete headings).} Or it may be that Oracle was terminated by some other process for some reason.

We did util c/6 to unlock abc01, and a rerun of p_manage_102 with delete flag "1", followed by p_manage_02, was successful.

Article last edited: 10/8/2013