How To Manage The Error: ORA-00054: Resource Busy And Acquire With NOWAIT Specified ORA-06512 Approving Workflows (Doc ID 1628725.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Workflow - Version 12.1.2 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

For the following error Approving Workflows:

ORA-00054: Resource Busy and Acquire with NOWAIT Specified ORA-06512

There are many possible causes of the ORA-00054 , but before reviewing the known notes referenced in this note, please check and increase the SGA size to test and monitor the system.

Below is the study case, this ORA-00054 can occur in any other situations when running a program when the system has a high load, not only on Workflow Approvals.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms