1 / 27

We’re Off To See The Wizard! Eliminate Unnecessary Patch Testing With Oracle's Patch Wizard !

We’re Off To See The Wizard! Eliminate Unnecessary Patch Testing With Oracle's Patch Wizard !. Mello-Dee Simmons Liza Klosterman. Introduction. Who We Are Largest community-owned utility in Florida and the eighth largest in the United States.

santa
Download Presentation

We’re Off To See The Wizard! Eliminate Unnecessary Patch Testing With Oracle's Patch Wizard !

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. We’re Off To See The Wizard!Eliminate Unnecessary Patch Testing With Oracle's Patch Wizard! Mello-Dee Simmons Liza Klosterman

  2. Introduction • Who We Are • Largest community-owned utility in Florida and the eighth largest in the United States. • Electric system currently serves more than 420,000 customers in Jacksonville and parts of three adjacent counties. • Water system serves more than 305,000 water customers and 230,000 sewer customers; over 80% of all water and sewer utility customers in our service area. • Our Testing Dilemma • 21 Modules • Mandatory Payroll Patch Testing • 195 to 250 hours of user testing, seven times per year

  3. Our Search for an Answer • Patch readme file • Did not contain depth of information required • Patch log file • 50 pages long • AOL and FND objects, java files affected • Oracle Support • After months of working with us, this response was posted in the open SR: “There is no other information or help that can be afforded this customer for this issue at this time.”

  4. The Oracle Patch Wizard • Recommend patches for the current code level • Recommend patches that bring the system to a new code level • Check if a particular patch has already been applied to the system • Identify unapplied prerequisite patches for recommended patches • Perform Impact Analysis for all recommended patches • Aggregate Impact Analysis for top-level patches and their un-applied pre-requisite patches. • Download and merge patches

  5. Setup and Execution • Requires System Administrator privileges and a My Oracle Support account • Menu Path: [System Administrator] Oracle Applications Manager -> Patching and Utilities

  6. Select “Patch Wizard” from the “Select Feature” drop-down box

  7. Set the Patch Wizard Preferences

  8. Designate a staging directory and set your My Oracle Support credentials The staging directory must be a server directory that you have write access to Interesting note: In R12.1, when manually copying patches to the server, they must reside in a subdirectory of your staging directory called “nonad”. For our example above, even though our staging directory is /tmp, the patches actually are copied to the /tmp/nonad directory.

  9. Enter your My Oracle Support account information Remove the default information from the Web Proxy Setup section

  10. Analyzing a Patch From the main Patch Wizard screen, click on “Recommend/Analyze Patches” Task

  11. Enter patch number(s) to be analyzed (separate multiple patches by commas)

  12. Check the status of the analysis by clicking on the “Job Status” icon on the main Patch Wizard screen Refresh Results Click “Details” to view the patch analysis.

  13. Basic Patch Information Click “Impact” to view the detail patch analysis.

  14. Patch Analysis Summary Screen • Direct Impact - Files directly impacted by the patch • Indirect Impact - Files, Menu Navigation Paths and Diagnostics Tests that are affected by the patch

  15. Direct Impact Summary Applications Patched: Applications modules that have files directly impacted by the patch. File Types Installed: Displays the File Types that are directly impacted by the patch.

  16. New Files Introduced: Displays new files included with this patch

  17. Existing Files Changed: Files included in the patch that are a newer version than current existing files in the database Highlighted file names are linked to file update history

  18. File update history:

  19. Existing Files Unchanged: Files included in the patch that will not be applied to the database because their patched version would be older than what currently exists

  20. Indirect Impact Summary Unchanged Files Affected: Files in the system that are not directly changed but have dependencies on files that would change Menu Navigation Trees Affected: Applications, responsibilities and the number of active users whose menu navigation trees would be affected

  21. Menu Paths Affected (Link): Detail screen shows the exact menu navigation paths to the patched JSPs and Forms.

  22. Tips and Tricks • The Patch Wizard does not have the ability to analyze non-Applications patches, such as CPU security patches and other database patches • The Patch Wizard also cannot analyze a patch that is password protected • The changed file count in patch log may not match the Patch Wizard analysis • AD tables are modified as being used by adpatch itself, Patch Wizard ignores these counts • There are objects recompiled and used for advanced queuing, not modified by the patch • The count of packages modified is higher in the patch log than the count shown in the patch analysis, which is caused by dependencies. A dependent package will show in the log as changed, due to recompilation because of the dependency; but the contents will not change, and therefore will not be listed in the patch analysis.

  23. A patch is submitted for analysis, the analysis appears to complete without errors, but the patch analysis comes back empty. Log file may show the error: “No Global View APPL_TOP found”; but often, there are no error messages at all.

  24. The Fix: Have your dba run adadmin with the following options: • Option 2 : Maintain Applications Files Menu • Option 5 : Maintain snapshot information • Option 2 : Update current view snapshot Once the program successfully completes, run the Patch Wizard again and re-analyze patches. This process often solves many odd, unexplained or seemingly unrelated errors; consider trying this before opening an SR with Oracle Support for problems.

  25. Conclusion Oracle’s Patch Wizard • One of the best-kept secrets of the Oracle Applications; there are even Oracle Engineers that are not aware of its existence. • One of the best tools available to Oracle System Administrators and support personnel for planning and executing patch application. We have achieved an 80% reduction in user hours required for Payroll patch testing alone!

  26. If your users are tired of testing modules seemingly unrelated to patches being applied; take advantage of Oracle’s Patch Wizard. Not only will you be able to eliminate unnecessary testing; but you can also show the users that do have to test, just exactly what they need to test and why.

  27. Questions?

More Related