resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at

Error:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at "SIV.PKG1_CHG_DB_CNFG",

Investigation:Find the locking sessions

select do.owner,do.object_name,do.object_type,dl.session_id,vs.serial#, vs.program,vs.machine,vs.osuser from dba_locks dl,dba_objects do,v$session vs where do.object_name ='SIV.PKG1_CHG_DB_CNFG' and do.object_type='TABLE' and dl.lock_id1 =do.object_id and vs.sid = dl.session_id;

Solution:Kill the session locking the object then resubmit

alter system kill sessions 'sid,serial#' immediate;

http://sivaora.blogspot.in/2012/01/ora-00054-resource-busy-and-acquire.html