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.
