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:
$ 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.