oracle apps dba blog

Dear Readers,
In certain scenarios you will be in a situation that you have pause the existing adpatching
and apply a patch in between.This is little bit tricky but still there is way to do that.but utmost care
has to be taken while doing this.

before that let us understand how adpatch works.

adpatch reads the .drv(driver) file in the patch and does the actions accordingly.It creates two Internal tables
in APPLSYS account called AD_DEFERRED_JOBS and FND_INSTALL_PROCESSES for controlling adworkers,
the workers statuses are controlled in these tables.
Also the Actions of the adpatch are stored in .rf9 file format in $APPL_TOP/admin/$TWO_TASK/restart directory..
when ever an adpatch is restarted from a failed session,it looks in to this folder to do
the restart work from where it has failed!.

Coming to the Actual procedure how to apply an interim ad patch do the following procedures.

1. Login adctrl and choose the option (tell the manager that a worker failed its job) — to stop
the existing patching…

2.login to APPLSYS and create backup of the two tables 1.AD_DEFERRED_JOBS ,
2.FND_INSTALL_PROCESSES

3. take a backup of the restart folder(or directory) under $APPL_TOP/admin/$TWO_TASK/

4.Apply the Interim(Intermediate ) patch successfully ,when asked for to continue
with failed session in adpatch say No and to the next question choose Yes
(so that you will erase the failed session and start a fresh patching).

5.After finishing the Intermediate patch ,restore the tables AD_DEFERRED_JOBS and
FND_INSTALL_PROCESS and the restart directory under $APPL_TOP/admin/$TWO_TASK.

6.login to adctrl and instruct the manager to restart the jobs.

7.Return to the original patch directory and invoke adpatch and now it will
ask “whether to continue with failed session”.
You have to give “Yes” and proceed with the original patching…

You May face this kind of issues while Upgrading the Oracle Apps (applying maintenance pack).

Your Comments,questions are welcome.
– Vivek R