Tuesday, May 22, 2007

Merging patches

I had to install the CPU April 2007 patches to a test environment.
I started with the e-Business Suite patches, you also have to patch all other environments that work with the EBS. Every part of the EBS environment has to be patched. Oracle recommends that patches are applied in the following order :
1. Oracle database (opatch)
2. Oracle Application server
3. Oracle e-Business Suite

This means, I had to patch the database (9.2.0.8), the http server, forms and the 8.0.6 home.
After these patches I also had to apply 20 EBS patches. The EBS CPU patches are not cumulative, so you also have to apply earlier CPU patches.
Because of this, I had to apply 20 patches for the EBS 11.5.9 release. I decided to use the admerge tool to merge the patches into one big patch. Admerge merges all patches from one directory into one patch. The tool knows in which order to apply the patches. Using admerge will save time. Just be sure to know if any patch has any post-install steps...
Before merging, be sure to place all patches to be merged into one directory...for example the 'patches' directory. Also create a target directory for the merged patch..'merged'.



admrgpch patches merged

Executing the merge of the patch drivers
-- Processing patch: patches/3578012
-- Done processing patch: patches/3578012
-- Processing patch: patches/3578012_NL
-- Done processing patch: patches/3578012_NL
-- Processing patch: patches/3748835
-- Done processing patch: patches/3748835
-- Processing patch: patches/4278155
-- Done processing patch: patches/4278155
-- Processing patch: patches/4278155_NL
-- Done processing patch: patches/4278155_NL
-- Processing patch: patches/5479643
-- Done processing patch: patches/5479643
-- Processing patch: patches/5479643_NL
-- Done processing patch: patches/5479643_NL
-- Processing patch: patches/5571208
-- Done processing patch: patches/5571208
-- Processing patch: patches/5571208_NL
-- Done processing patch: patches/5571208_NL
-- Processing patch: patches/5571211
-- Done processing patch: patches/5571211
-- Processing patch: patches/5571211_NL
-- Done processing patch: patches/5571211_NL
-- Processing patch: patches/5658489
-- Done processing patch: patches/5658489
-- Processing patch: patches/5661617
-- Done processing patch: patches/5661617
-- Processing patch: patches/5711474
-- Done processing patch: patches/5711474
-- Processing patch: patches/5711474_NL
-- Done processing patch: patches/5711474_NL


Copying files...
5% complete. Copied 4 files of 70...
10% complete. Copied 7 files of 70...
15% complete. Copied 11 files of 70...
20% complete. Copied 14 files of 70...
25% complete. Copied 18 files of 70...
30% complete. Copied 21 files of 70...
35% complete. Copied 25 files of 70...
40% complete. Copied 28 files of 70...
45% complete. Copied 32 files of 70...
50% complete. Copied 35 files of 70...
55% complete. Copied 39 files of 70...
60% complete. Copied 42 files of 70...
65% complete. Copied 46 files of 70...
70% complete. Copied 49 files of 70...
75% complete. Copied 53 files of 70...
80% complete. Copied 56 files of 70...
85% complete. Copied 60 files of 70...
90% complete. Copied 63 files of 70...
95% complete. Copied 67 files of 70...
100% complete. Copied 70 files of 70...
Character-set converting files...
15 unified drivers merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.


So, this way I have to only apply one patch...the u_merged.drv

8 comments:

Anonymous said...

Hi!
Thank you for sharing about admerge. I plan to use this to start the installation of CPU for my EBS 11.5.10.2 with database 10.2.0.2.
Did you have any error when running the merged patch ?
Do you think you saved a lot of time by using this utility ?
Thanks again !

Bas Klaassen said...

Hi Claude,

I received no errors and I am sure it has saved me lot of time. Instead of applying 10 or more patches, I only had to apply 3 merged patches...

Anonymous said...

A very nice document.

Mohammed Nayeem said...

Hello!

Can you please suggest on how can we decide which patches can be merged.

Regards,
Nayeem

Bas Klaassen said...

Hi Nayeem,

you can merge patches when you have a lot of themto install.
Some dba's already merge when only two patches must be installed. So it's up to you when to merge patches. Sometimes you want tp apply a patch and you need a lot of prereq patches also. Then merging is a good and time winning option.

Mohammed Nayeem said...

Hi Bas,

Thanks for your reply.
can u please expedite on how and on what basis i need to decide which patches can be merged and which patches can't be merged.Do i need to check on the drivers it is containing,languages...etc.,

Unknown said...

At the moment we are investigating a problem with a merged patch.

There's a view wich is missing a column when the patches are merged before applying them. Applying them seperatly generates the view with the correct columns.

This would be a downer if the outcome is that merging patches is not reliable.

sixdengineering said...

Wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
Point cloud to 3D Model London
Point cloud to 3D Model
Reverse Engineering Services in London