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

    Oracle: update_cursor z66, update_cursor1 z52, io_z34_write; old log written to

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

    Description:
    I can not login to the GUI on the test server. I found that pw_library and usr_library was set to ‘abct00’.

    I corrected this to abc00, did “source aleph_start”, and restarted the pc_server.

    Still, I get oracle errors:

    Oracle error: update_cursor z66
    ORA-00942: table or view does not exist

    Oracle error: update_cursor1 z52
    ORA-00942: table or view does not exist

    Oracle error: io_z34_write
    ORA-00942: table or view does not exist

    There may be something that I forgot to do.

    Also, the pc_server_6892.log is not growing, while the log messages are all in the pc_server_6892.log.1201.1810.

    Resolution:
    The pc_server_6892.log not growing while the log messages are all in the pc_server_6892.log.1201.1810. is certainly not right.

    I restarted the pc_server 6892 and then did this:

    >>ps -ef | grep 6892
    abct 8631 7756 0 15:01 pts/5 00:00:00 grep 6892
    abct 14841 1 0 2008 ? 00:00:00 csh -f /exlibris/aleph/a17_2/aleph/proc/pc_server 6892
    abct 14947 14841 0 2008 ? 20:50:48 /exlibris/aleph/a17_2/aleph/exe/pc_server_main 0 6892

    There were no child processes and the "20:50:48" (20 hours, 50 minutes, 48 seconds of cpu time) is certainly not right.

    I killed this process ("kill -9 14947"). This also killed the 14841 process.

    Then I did util w/3/3 to restart the pc_server 6892. It looks better now:

    >>ps -ef | grep 6892
    abct 8692 1 1 15:03 pts/5 00:00:00 csh -f /exlibris/aleph/a17_2/aleph/proc/pc_server 6892
    abct 8704 8692 0 15:03 pts/5 00:00:00 /exlibris/aleph/a17_2/aleph/exe/pc_server_main 0 6892
    abct 8714 8704 0 15:03 pts/5 00:00:00 /exlibris/aleph/a17_2/aleph/exe/pc_server_main 0 6892
    abct 8715 8704 0 15:03 pts/5 00:00:00 /exlibris/aleph/a17_2/aleph/exe/pc_server_main 0 6892
    abct 8716 8704 0 15:03 pts/5 00:00:00 /exlibris/aleph/a17_2/aleph/exe/pc_server_main 0 6892
    abct 8717 8704 0 15:03 pts/5 00:00:00 /exlibris/aleph/a17_2/aleph/exe/pc_server_main 0 6892
    abct 8718 8704 0 15:03 pts/5 00:00:00 /exlibris/aleph/a17_2/aleph/exe/pc_server_main 0 6892

    There are five child processes, as there should be.

    After the above, they were able to log in.


    • Article last edited: 10/8/2013