Patches

Types of Patches:
===============

Standalone/Oneoff 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 :
========

$AD_TOP/patch/115/sql/adphrept.sql

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
==========================

Note:139684.1
ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/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:
==========================

options=noautoconfig

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

copyportion

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

databaseporion

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

generateportion

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

hotpatch

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


integrity

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)

maintainmrc

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

prereq

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)

forcecopy

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 :
========

adadmin

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

To Disable:
========

adadmin

$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

Generates
u_merged.drv
admrgpch.log

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.

That is FND_INSTALL_PROCESSES and
AD_DEFFERED_JOBS

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.