OATM Migration fails with ORA-54: resource busy and acquire with NOWAIT specified (Doc ID 369198.1)

Last updated on APRIL 09, 2015

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2013***

Symptoms

When attempting to execute the commands to migrate to OATM, you get errors like :

...
APPLSYS FND_CONCURRENT_REQUESTS TABLE X
ORA-00054: resource busy and acquire with NOWAIT specified

APPS AQ$_JTF_FM_RAPID_M_QTBL_T INDEX X
ORA-00054: resource busy and acquire with NOWAIT specified

APPS JTF_FM_RAPID_B_QTBL TABLE X
ORA-00054: resource busy and acquire with NOWAIT specified

APPS JTF_FM_RAPID_Q1_QTBL TABLE X
ORA-00054: resource busy and acquire with NOWAIT specified

APPS JTF_FM_RAPID_Q2_QTBL TABLE X
ORA-00054: resource busy and acquire with NOWAIT specified
...


The error can occur for different objects - these are just some examples.

Cause

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