ORA-00060: deadlock detected while waiting for resource

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

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