Q

Identifying patch prerequisites

Is there any script or tool by which I can identify all the prerequisite patches for any given apps patch?

Is there any script/tool by which I can identify all the prerequisite patches for any given patch?
Not really, although there are many tools that can help. In recent years, Oracle has increased the functionality of its patching tools, and publishes extensive information about patches and patch sets.

Oracle publishes extensive information on MetaLink regarding patches and patch prerequisites. The tools AutoPatch,

AD Administration, and other AD utilities can make patching easier. However, each site needs to have standard procedures for patching, and keep track of the patches which are applied to each instance. (You DO have a development, a test and a production instance, don't you?)

For information about how to use these utilities, refer to the AD Utilities Reference Guide, Release 11i (11.5.7).

As an Oracle Applications user, you may want to check out the applications diagnostics.sql files. For each of the core applications, there are some routines which identify from the database what patch sets and individual patches have been applied.

This was first published in June 2004

Dig deeper on Oracle E-Business Suite

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close