Oracle ORA-00054: resource busy and acquire with NOWAIT specified

Details

Category: Technical

Published on Tuesday, 05 March 2013 21:36

Written by Administrator

Hits: 580

Tweet

Run in SQL*Plus or SQL developer

select a.sid, a.serial#  from v$session a, v$locked_object b, dba_objects c 
where b.object_id = c.object_id 
and a.sid = b.session_id
and OBJECT_NAME='YouTableName';

Then note both the sid and serial and run

alter system kill  session 'sid,serial#' IMMEDIATE;

If this still do not work, your last bullet is to kill the Unix process which is still hanging on your database server!

here is how to find the unix process to kill

Run in SQL*Plus or SQL developer

select p.spid,s.sid,s.serial#,s.username,s.status,s.last_call_et,
       p.program,p.terminal,logon_time,module,s.osuser 
from V$process p,V$session s 
where s.paddr = p.addr and s.status = 'ACTIVE' and 
      s.username not like '%SYS%'; 

and finally run a

kill –9 spid

if this still don’t not work, your best friend is Google

You might also like:

407 days ago

Oracle Please set ORACLE_UNQNAME to database unique name

if you encounter this error while starting oracle /etc/init.d/oraemctl start Starting Oracle EM D

601 days ago

Install XEN Server without an Optical Drive

Citrix XenServer is a complete, managed server virtualization platform built on the powerful Xe

1034 days ago

Map Synology network drive under linux

How to mount your Synology NAS (or any other NAS brand) shared folder under Linux using CIFS. C

1036 days ago

Advanced Oracle Weblogic start/stop script

The Oracle WebLogic 11g application server product line is the industry's most comprehensive J

1036 days ago

Basic operations with XEN server: export, import of VM templ

More and more I am using XEN at work, and here is a small how to of some very common operations.

1366 days ago

Debian Lenny how to

  Short description of how to accomplish some specific task in Debian Lenny. How to install Sun ja

CedThumbnails

• Next >