Resource busy and acquire with NOWAIT specified" -- can't make it stop

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

Description:
In running clear_vir01, or some other process, at a time when the www_server, pc_server, or other processes are active, you find that you always get the message:

ORA-00054: resource busy and acquire with NOWAIT specified

-- no matter what you do.

Resolution:
This message indicates that another process is using this table. If the job you are running is clear_vir01 (or util x/8), then the table is most likely the z05 or z110.

If the pc_server or the www_server is running, then it may be that someone has initiated a request which reads or updates the table. If the process you are trying to run is critical to OPAC functionality -- as clear_vir01 can be if one of the vir01 tables is not working --, try stopping the www_server and/or the pc_server and re-running the job. (If it is not critical, then wait until night-time to run the job.)

In this case, the clear_vir01 was hanging trying to drop the z05. When this happens, you can kill the clear_vir01 -- and the util_a_17_1_b process it spawns -- and try doing util a/17/1 for the vir01 z05 -- or s+ vir01 and then "drop table z05".

In this case, none of these worked. Even stopping all the servers and doing the drop didn't work.

It was only after we
1. ran aleph_shutdown
2. stopped/restarted Oracle
3. ran aleph_startup
that we were able to successfully drop the z05 and z110.