Select Page

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

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

The Oracle error ORA-00054 can be solved by executing as DBA the following query

 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%';

This will return the PID of the hanging process

You can then SSH to the server ruining oracle and kill the process

 kill -9 PID

 

About The Author

I worked with various Insurances companies across Switzerland on online applications handling billion premium volumes. I love to continuously spark my creativity in many different and challenging open-source projects fueled by my great passion for innovation and blockchain technology.In my technical role as a senior software engineer and Blockchain consultant, I help to define and implement innovative solutions in the scope of both blockchain and traditional products, solutions, and services. I can support the full spectrum of software development activities, starting from analyzing ideas and business cases and up to the production deployment of the solutions.I'm the Founder and CEO of Disruptr GmbH.

Categories