Logo Background

Oracle Patches Family Build

  • By on January 4, 2009 | No Comments

    Standalone/One off patches :

    This is used to define patch created to fix single/particular problem.

    Mini Pack :

    This is group of oneoff patches for a particular product like INV, GL, AP and named like 11i.GL.E ( means this group of patches contain fix for 11i GL product (General Ledger till time E is released ) This is cummutative which means it will include 11i.GL.A, 11i.GL.B ….11iGL.D till 11i.GL.E earlier in 10.7 it used to called as patchset.

    Family Pack :

    Group of mini packs in one family buldeled together is called as family pack. they are usually named as 11i_PF. Few example of falilies are SCM ( 11i.SCM_PF.G ), ATG ( 11i.ATG_PF.H ) _PF indicate Product Family Pack

    Maintenance Pack :

    Group of family pack together is called as maintenance pack. So if you say your Verison is 11.5.10 then its maintenance pack 10 ( 3rd digit is maintenance pack )

    Special Patches

    Consolidated patch:

    This is a collection of one-off fixes for a Family Pack or Maintenance Pack; Oracle Applications 11.5.10 Consolidated Update 2 (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.

    Drivers – c,d,g & u

    1. cXXXXXXX.drv – c stands for copy driver file , used to update the file system with new file versions

    2. dXXXXXXX.drv – d stand for Database driver & used to update database level code and objects

    3. gXXXXXXX.drv – g stands for generate driver and is used to generate forms, PL/SQL libraries, reports, and menus

    4. uXXXXXXX.drv – merged or unified driver which combines the c,d and/or g drivers

    Patch Reporting Tools :

    1. Using the adphrept.sql script
    2. Executing the patchsets.sh utility
    3. Querying the database
    4. Using Oracle Application Manager (OAM)

    1. Using adphrept.sql

    Location :


    Generates a XML report [adfilerep.xml]

    Execute as

    $sqlplus apps/apps_password 1 ALL ALL ALL ALL ALL ALL ALL ALL ALL N N N N N

    Copy the xml file to OA_HTML to view in browser

    Note : adphrept.sql options

    Query_depth 1—Lists details of patches only
    2—Lists details of patches and their bug fixes only
    3—Lists details of patches, their bug fixes, and bug actions
    Bug_number Lists details for one bug number or ALL
    Bug_product Lists details for one product or ALL
    End_date_from Lists start date for a date range or ALL
    End_date_to Lists end date for a date range or ALL
    Patchname Lists details for a patch name or ALL
    Patchtype Lists details for a patch type or ALL
    Level Lists details for a patch level or ALL
    Language Lists details for a language or ALL
    Appltop Lists details for a specific APPL_TOP or ALL
    Limit to forms server Limits the list’s scope (Y/N)
    Limit to web server Limits the list’s scope (Y/N)
    Limit to node server Limits the list’s scope (Y/N)
    Limit to admin server Limits the list’s scope (Y/N)
    Only patches that change db Limits the list’s scope (Y/N)

    2. Using patchsets.sh

    $patchsets.sh connect-apps/apps_password

    patchsets.sh –h à give options

    Sample Output :

    3.Querying the Database for Patches

    SELECT bug_number
    FROM ad_bugs
    WHERE bug_number IN (‘patch_number’, ‘patch_number’, . . .)
    ORDER BY bug_number DESC;

    Adpatch – option:


    If you are applying number of patches out of which 4-5 patches run autoconfig then use this option & run autoconfig in last patch or manually (This will save your patching timing , first patch performance tip )

    compiledb(def) or nocompiledb

    Use no compiledb if you have multiple patch then compile database objects in last patch

    compilejsp(def) or nocompilejsp

    Use no compilejsp if you have multiple patch then compile jsp in last patch


    Tells adpatch whether to run commands normally found in a copy driver.


    Tells adpatch whether to run commands normally found in a database driver.


    Tells adpatch whether to run commands normally found in a generate driver


    Tells AutoPatch to apply a patch regardless of whether the Oracle Applications system is in maintenance mode.


    Tells adpatch whether to perform patch integrity checking, which verifies that the version of each file referenced in a copy action matches the version present in the patch (There are overheads with this)


    Tells adpatch whether to automatically maintain the MRC schema after running actions normally found in the database driver. The MRC schema is only maintained if the MRC feature is enabled


    Tells adpatch whether to perform prerequisite patch checking prior to running patch driver files that contain actions normally found in the copy driver. (With lateset AD patch , default behaviour is changed from prereq to noprereq)


    The forcecopy command copies the files in a patch to the Applications file system without comparing the version number of the patch files with existing files

    About Maintenance Mode:

    As of ADI – Maintenance Mode must be enabled.

    To Enable :


    $AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

    To Disable:


    $AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

    Note :

    We can also go to adadmin and follow the option to enable and disable Maintanance Mode.

    adpatch – options

    Option Purpose

    novalidate Prevents adpatch from validating all schema connections
    noprereq Prevents adpatch from checking the existence of prerequisite patches
    nocompiledb Prevents adpatch from compiling database objects
    nocompilejsp Prevents adpatch from compiling JSP objects
    noautoconfig Prevents adpatch from running autoconfig after the patch has completed
    nogenerateportion Prevents adpatch from compiling forms, menus, and plls
    hidepw Prevents passwords from being displayed in log files
    hotpatch Allows adpatch to be run when the instance is not in maintenance mode

    Eg: adpatch options-nocompiledb,novalidate

    AD Merge :

    This utility is to merge the patch inorder to reduce the timings

    Applying a group of similar patches

    Similar patches unbundled in same folder
    ./admrgpch /source_dir /target_dir


    Note 228779.1, “How to Merge Patches Using admrgpch.”

    AD Control :

    This Utility is used when we are running the patch, we can see all the details about the patch . ie) All about workers etc.,
    This will work till the both tables drop.


    These are the two tables created while the patch starts and it will be dropped when the patch is applied or completed.
    Note : Adctrl options about workers will works till the above two tables is in use .

    Command Used : adctrl

    Note : While the patch is running and if it fails in the middle and if we want to ignore it there is also a 8th option but is will not be listed above. The 8th option is

    8. Enter the worker number(s)/range(s) (or) all for all workers.

    These is to kill that particular worker. (to ignore)

    DB Patches:
    Eg: patch 2617419

    $export PATH-$PATH:/[path_of_2617419]/Opatch
    $export PERL5LIB-[path_of_PERL]/lib
    $opatch lsinventory
    $opatch apply

    Note :

    If the opatch fails :

    There may be a patch_locked file located under the hidden directory $ORACLE_HOME/.patch_storage.

    The opatch utility may not be executed until the patch_locked file is removed.

    » Page, Home Page, Site Optimization
Leave a Comment