Tuesday, January 26, 2010

Advanced Patch Search Options With Oracle Support

With Oracle's Patch search there are several useful Advanced Search options which extend the flexibility of the support tool. This feature can be used to locate Oracle Application patches that meet a wide variety of criteria. I've used this feature several times to quickly find patches needed to resolve a specific problem.



This search feature is not available on the Patch Search section under the My Oracle Support Patches & Updates tab. The feature is listed in the Patching Quick Links section under the heading Advanced "Classic" Patch Search. In the Patching Quick Links section there are several other links that are useful for an APPS DBA. There are links for recommended patches and latest packs for both releases 11i and 12. Per Oracle's help screen the Classic Advanced Search feature will eventually be moved into the Patch Search section, but is currently unavailable from there.



Under Classic Advanced search the APPS DBA has the ability to search for patches that have specific file versions. This option has been useful to locate a patch which includes a certain version of a file. Sometimes Oracle Support notes will list file versions that resolve a known problem. If you do not have the latest file, the search feature will list the patches that contain that file.



Spend some time using the advanced patch search features and the Patching Quick Links. Developing an understanding of the options available will allow for quicker searches in the future. This can help lead to faster problem resolution.

No comments: