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