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