ORA-00060: deadlock detected while waiting for resource
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
Our Library Staff using ACQ to check in something, but got a timeout.
By checking the oracle log (This log keeps growing):
> tail -f /exlibris/app/oracle/diag/rdbms/aleph0/aleph0/trace/alert_aleph0.log
ORA-1653: unable to extend table USR00.Z105H by 8192 in tablespace TS0
ORA-1653: unable to extend table USR00.Z105H by 8192 in tablespace TS0
ORA-1653: unable to extend table USR00.Z105H by 8192 in tablespace TS0
......
By checking the NAME M TOTAL M USED M FREE % FREE
--------------- --------- --------- --------- ------
TS0 9120 9024 92 1.01%
It looks like the tablespace is full. So I run util/0/13/3 to add datafile but I got error:
idle> idle> alter tablespace TS0 add datafile '/exlibris/oradata/aleph0/aleph0_ts0_04.dbf' size 4000M
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
Do I need to shut down oracle to add tablespace datafile? How can I resolve this problem?
Resolution:
First, I suggest that you check (with util o/13/1) to confirm that the datafile has not been added despite this message.
Assuming it hasn't, I suggest that you try adding the file again (since this can sometimes be a temporary condition).
If you get the same error on this second attempt then, yes, I think you will need to restart Oracle.
[From site:]
We tried another time and it is working now.
- Article last edited: 10/8/2013