afcmgr.odf - ORA-00054

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

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:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...