Sunday, March 27, 2016

afcmgr.odf - ORA-00054: resource busy and acquire with NOWAIT specified

afcmgr.odf - ORA-00054: resource busy and acquire with NOWAIT specified

Got this error while patching afcmgr.odf
ALTER TABLE APPLSYS.FND_CONCURRENT_QUEUES STORAGE (FREELISTS 4)
AD Worker error:
The following ORACLE error:

ORA-00054: resource busy and acquire with NOWAIT specified
occurred while executing the SQL statement:

The reason for this error is that Concurrent Manager Service is up. Because it is locking FND tables, adpatch is unable to obtain a lock

Solution:

To implement the solution, please execute the following steps:

1. Please stop all Apps services as follows:
cd $COMMON_TOP/admin/scripts/[CONTEXT_NAME]
$ adstpall.sh apps/password

2. Restart adpatch, continue previous session.
3. Start adctrl utility and choose option 2. to restart the worker that failed.

Now the Patch should continue and complete successfully.

Note: Always before running adpatch please stop all Apps services to avoid similar issues.

No comments:

Post a Comment