Missing R12.1.1 preinstall patches after starting the R12.1.1 Upgrade

I started the most recent pass of the R12.1.1 upgrade and then realized I had forgotten some patches. Some of the patches had not been download from MOS, because I tried to download too many at a time. I think there is a limit of about 100 patches per download, but I don’t know the exact number. Therefore, I only downloaded about 100 of the 120 patches I intended to download.

I started the upgrade using the u6678700.drv, in $AU_TOP/patch/115/driver and then I double checked my patch directory. I was surprised and worried when I realized I did not have all the patches. I was missing some very important patches, included in an earlier post, and sumarized below, including the R12.1 CUP1, 7303029 and others.

The list from earlier for the R12.1 preinstall=y patches:

7303029, 7648869, 8230656, 8351855, 8429275, 8495719, 8509517, 8517880, 8615142, 8712047, 8731432, 8752951, 8764069, 8781600, 8850587, 8865466, 8871012, 8942413, 8967918, 9062910, 9082021, 9202645, 9257954, 9290222, 9491856, 9504903, 9560244, 9586498, 9726737, 9799876, 9868229, 9903933, 9918101, 9947835, 10011700, 10029457, 10041471, 10096115, 10096191, 10144929, 10163624, 10163753, 10170555, 10198811, 10221534, 10235226, 10275581, 10358280, 10359715, 10393730, 10420245, 11071399, 11653739, 11767692, 11847569, 11928146,, 12344218, 12347791, 12372035, 12382774, 12387835, 12422840, 12553436, 12578648, 12648752, 12651338, 12682665, 12877002, 12877611, 12912302, 12930626, 12944782, 12990345, 12992125, 13016846, 13019385, 13040251, 13243594, 13248921, 13335019, 13356426, 13390676, 13397299, 13403786,  13451293, 13509912, 13544907, 13545598, 13557244, 13577549, 13598940,  13684949, 13695167, 13774403, 13793279, 13799611,  13820304, 13833174, 13837821, 13856969, 13864126, 13872862, 13917170, 13931180, 13978746, 14026963

I got a little excited when I realized I had jeopardized all my earlier work, but not double checking that the patches had been accurately uploaded to the server. However, I know how to apply a patch in the middle of the maintenance pack, by making a copying of the $APPL_TOP/admin/SID/restart directory and a copy of the FND_INSTALL_PROCESSES table (create table applsys.fnd_install_processes_backup as select * from applsys.fnd_install_processes).

After making a backup of the table and directory, I stopped the patch using adctrl and applied the missing R12.1.1 preinstall patches. After copying the restart directory and fnd_install_processes table from the backups, I restart the 6678700 R12.1.1 Maintenance Pack. To my surprise, it never asked me if I wanted to continue with the previous patch, and started the 6678700 driver from the beginning. I was mortified. I was sure the patch would fail, as this has happened to me before, with failure as the only option, and recovery of the database would be necessary.

However, to my surprise, the patch worked just fine. After further investigation, the patch had previously reached phase A25, when I stopped it to apply the missing patches. These phases contain only odf and xdf files. These object descriptor files and xml descriptor files prepare the instance and can be re-run. The odf and xdf files continue through phases A35. Therefore, any failures before the end of phase A35 can be restarted without using the copies of the restart directory and backup of the FND_INSTALLED_PROCESSES table.

This entry was posted in E Business Suite, R12.1 Upgrade by mswing. Bookmark the permalink.

About mswing

Software Engineer using Pascal, C, and Ada to develop DSP code. Ingres DBA and Developer Informix DBA and Developer Oracle DBA and Object Modeler Oracle Parallel Server DBA Oracle Applications DBA EBS Upgrade Expert Author and Instructor