Adpatch Fails While Executing afcmgr.odf. Error : The table is missing the index FND_CONCURRENT_QUEUES_N2 ORA-00054: resource busy and acquire with NOWAIT specified

Dear All,

I received one email from one reader mentioning below error message

Adpatch Fails While Executing afcmgr.odf. Error : The table is missing the index FND_CONCURRENT_QUEUES_N2 ORA-00054: resource busy and acquire with NOWAIT specified

When i checked metalink then found below note:

[ID 295992.1]

I can't paste content of metalink over here but you can also use the following workaround:

afcmgr.odf is failed because concurrent manager was running and locks on concurrent manager tables.

Workaround: stop concurrent manager when applying this patch "Patch 3262159 (11i.FND.H) fails while executing afcmgr.odf.:.

You can check the concurrent manager status with following query:

SQL> select object_name from all_objects
where object_id in (select object_id from v$locked_object)
and upper(object_name) like 'FND%';

- If any locks found, release the locks on those objects. ( Shutting down the Database should release the locks on the object. Either do "shutdown immediate or shutdown normal" )

- Manually execute the adodfcmp command to load afcmgr.odf details.
e.g. Command to be used for executing ODF (for tables) :
adodfcmp userid=applsys/apps mode=tables   
odffile=/pd01/oracle/lprdappl/fnd/11.5.0/patch/115/odf/afcmgr.odf
touser=apps/ priv_schema=system/ changedb=yes           
logfile="log_table.log"
- Check logfile log_table.log.
This would execute the afcmgr.odf successfully.