How to Apply an 11i Patch When adpatch is Already Running

Step 1 Execute adctrl utility and shutdown the workers.

Step 2 Backup the FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table which is owned by the APPLSYS schema

Step 3 Backup the .rf9 files located in $APPL_TOP/admin//restart directory.

a. cd $APPL_TOP/admin/

b. mv restart restart_back

c. mkdir restart

Step 4 Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.

Step 5 Apply the new patch.

Step 6 Restore the .rf9 files located in $APPL_TOP/admin//restart_back

directory.

a. cd $APPL_TOP/admin/

b. mv restart restart_

c. mv restart_back restart

Stop 7 Restore the FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table which is owned by the APPLSYS

schema.

Step 8 Re-create synonyms

a. sqlplus apps/apps

b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;

c. create synonym FND_INSTALL_PROCESSES FOR

APPLSYS.FND_INSTALL_PROCESSES;

Step 9 Start adpatch, it will resume where it stopped previously.

Conclusion:

If you have wasted your time in main patch near about 8 to 10hrs. then you should take backup of FND_INSTALL_PROCESSES,AD_DEFFERED_JOBS and baclup of restart files which extension is .bk9,rf9 and these files located in $APPL_TOP/admin/sid/restart before quit the workers and then apply the pre-req. of patch and when you will go for main patch then before start the main patch restore the tables and backup files.