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.
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/
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/
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.
Post a Comment