Application Patch:
One of the most important and time-consuming aspects of an Oracle Applications DBA’s job is applying patches to the E-Business Suite.
One of the most important and time-consuming aspects of an Oracle Applications DBA’s job is applying patches to the E-Business Suite.
Patches
may be required to resolve problems with the application code, to fix
production issues, to install new features, or to upgrade components of the
technology stack.
Types of Application Patches:
There
are several different types of Oracle Applications patches. Below discussed are
the more common patches:
- Standalone/One-off patch: This is the simplest type of patch. It is created to resolve a specific bug.
- Minipack patch: This is a collection of one-off patches and enhancements related to a particular module. Alphabetic characters denote the Minipack version for the module; for example, the product code for the Application DBA utilities is AD, and version Minipack I of this product would be called AD.I.
- Family Pack patch: This is a collection of Minipack patches for a particular family group of application modules. Alphabetic characters denote the Family Pack version; for example, the J version of the Human Resources Suite Product Family would be HR_PF.J.
- Maintenance Pack patch: This is a collection of Family Packs that serves as a point-level release upgrade; Oracle Applications Release 11.5.10 is an example of a Maintenance Pack.
There are also other
special types of patches:
- Consolidated patch: This is a collection of one-off fixes for a Family Pack or Maintenance Pack; Oracle Applications 11.5.10 Consolidated Update2 (CU2) is an example of a consolidated patch.
- Interoperability patch: This is a patch that is required for Oracle Applications to function with a newer version of a technology stack component; for example, you would apply an interoperability patch when upgrading the database to version 10g.
- NLS patch: This is a patch that updates language-specific information for multi-language installations.
- Rollup patch: This is a collection of one-off patches that update code levels for particular products.
- Legislative patch: This is a special patch for HR Payroll customers; it contains legislative data for multiple countries.
Oracle Apps Patch drivers are
broadly classified in to two categories split driver and unified driver.
- Split Driver – means patch actions are divided by function i.e.
- cXX.drv – Copy Driver to change product files
- dXX.drv – Database Driver to change Database Objects
- gXX.drv – Generate Driver to generate new forms, messages, graphics
2. Unified
Driver – contains all three functions
(copy, database & generate) into single driver
- uXX.drv – Contains all three functions Copy, Database and Generate.
Copy Driver: For split patch, You must run copy driver
(cXX.drv) on all APPL_TOP containing one or more files being replaced by patch.
If confused or not sure which files are being replaced by patch then its good
idea to apply c driver on all tier i.e. Web, Forms, Concurrent Manager,
Administration Server.
Database Driver:
For split patch, You must run database driver (dXX.drv) on Administration
(Admin) Node. (This is usually same as Concurrent Manager Node). To find where
is your Admin Node run sql
SQL> select node_name,
support_admin from apps.fnd_nodes;
Generate Driver:
For split patch, You must run generate driver (gXX.drv) on all APPL_TOP
containing one or more files generated by patch. If confused or not sure then
its good idea to apply g driver on all tier i.e. Web, Forms, Concurrent amd Administration Server.
Unified Driver: For
unified patch (uXX.drv) , run it on all tier containing APPL_TOP i.e. Web, Forms, Concurrent Manager and
Administration Server.
If you are using shared
APPL_TOP/Application Tier then run split patch (c,d,g) or unified patch (u)
from any one node.
If you are confused about any driver
file (to apply or not) then run all driver on all nodes and AutoPatch (adpatch)
will determine appropriate action based on tier (forms, web, concurrent
manager) and ignore steps not required on that tier.
Order of application
for split driver (c,d,g)
This patch contains one or more
driver files to be applied with AutoPatch. Please apply the driver files in the
following order (if they exist):
- c011111.drv (This is the copy driver)
- d011111.drv (This is the database driver)
- g011111.drv (This is the generate driver)
The
process of applying the patch generally involves the following logical steps:
- Download and unbundle the patch.
- Identify patch drivers required for the patch.
- Place the instance in maintenance mode.
- Use the AD Patch utility to apply patch driver files.
- Perform any manual steps that may be required.