Thursday, November 1, 2012

Patch Wizard in Oracle EBS

Here is Oracle's  answer to question " How do I know what changes xxx patch does to my system , what is impact"

Patch Wizard is a Web-based utility in Oracle Applications Manager (OAM)

Navigation : Login to System Administrator

Oracle Applications Manager-->Patching and utilities -->
Select Feature ( Dropdown at right top corner ) Patch Wizard

There are different task names listed there for performing specific task.

Patch Staging directory is defined in "Patch Wizard Preferences" task

"Recommend/Analyze Patches" task allows you to analyze specific patch mentioned in text box.

Tip : If Metalink login does not connect from the Apps server,
the patch Zip file can be downloaded from metalink and FTP'ed to
Patch staging directory and /ad directory . Read light blue note
below the patch numbers box in "Recommend/Analyze Patches" task

This submits request set to run and once completed, Impact analysis is done and
presented in  "Recommended Patches Results" section

Note : I think there should be way to generate nice impact analysis document
for presenting it to management , but I could not get something similar yet.
There can be query to get the details in reader-friendly format.
Clicking on each hyperlink to see impact is cumbersome

Details on how to use patch wizard can be found at

http://www.in-oracle.com/Oracle-Apps/11i/patch-impact-analysis.php

http://docs.oracle.com/cd/E18727_01/doc.121/e12148/T531058T531063.htm

P.S. Till today I could not get query which will nicely display impact analysis. Crude way to provide the screen shots after clinking on impact details button  in patch wizard screens. I certainly believe there exists some query which will easily generate user friendly report on patch impact analysis.

No comments:

Post a Comment