ORA-00054: resource busy and acquire with NOWAIT specified
~御帝~Nov 29 2012 — edited Dec 2 2012--osinfo
AIX bomc3_svr1 3 5 00C58E964C00
--dbinfo
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
--alertlog
...
Current log# 2 seq# 7780 mem# 0: /oradata2/redo30.log
Current log# 2 seq# 7780 mem# 1: /oradata3/redo34.log
Thu Nov 29 22:03:01 BEIST 2012
GATHER_STATS_JOB encountered errors. Check the trace file.
Thu Nov 29 22:03:01 BEIST 2012
Errors in file /oracle/admin/bomc/bdump/bomc1_j001_643960.trc:
ORA-00054: resource busy and acquire with NOWAIT specified
Thu Nov 29 22:34:51 BEIST 2012
Thread 1 advanced to log sequence 7781 (LGWR switch)
Current log# 8 seq# 7781 mem# 0: /oradata3/redo24.log
Current log# 8 seq# 7781 mem# 1: /oradata1/redo40.log
Fri Nov 30 00:46:03 BEIST 2012
Thread 1 advanced to log sequence 7782 (LGWR switch)
Current log# 5 seq# 7782 mem# 0: /oradata2/redo21.log
Current log# 5 seq# 7782 mem# 1: /oradata3/redo37.log
Fri Nov 30 03:21:47 BEIST 2012
Thread 1 advanced to log sequence 7783 (LGWR switch)
Current log# 6 seq# 7783 mem# 0: /oradata2/redo22.log
Current log# 6 seq# 7783 mem# 1: /oradata3/redo38.log
Fri Nov 30 05:34:12 BEIST 2012
Thread 1 advanced to log sequence 7784 (LGWR switch)
Current log# 7 seq# 7784 mem# 0: /oradata2/redo23.log
Current log# 7 seq# 7784 mem# 1: /oradata3/redo39.log
Fri Nov 30 07:34:52 BEIST 2012
Thread 1 advanced to log sequence 7785 (LGWR switch)
Current log# 1 seq# 7785 mem# 0: /oradata2/redo29.log
Current log# 1 seq# 7785 mem# 1: /oradata3/redo33.log
...
帖子经 ~御帝~编辑过