Oracle Apps 11i/R12 AutoPatch adpatch / admsi.pl
Patching : is process of Bug Fix, adding new Functionality or enhancements. Depending on component (database, apps, forms/report) there are different tools to apply patches.
- adpatch – is utility to apply Oracle Apps Patches (This utility usually updates files under $APPL_TOP, $JAVA_TOP and Database objects)
- opatch – is utility to apply database and application server (10gR3 for forms, reports and web server) patches
- Shell scripts– to apply 6i (forms & report in 11i) and 9i (web server in 11i) patches
This post is focused on “adpatch” and covers Oracle’s documentation one should read in order to learn more on Apps Patching.
Tools used in apps patching
1. adpatch– (aka AutoPatch) is utility to apply apps patches
2. admrgpch– utility to merge multiple patches into single patch and then apply them as single patch using “adpatch“.
3. admsi.pl – Patch Application Assistant (PAA) utility to track and perform manual steps during patching (applicable for R12 only). More information here PAA Tool in R12
4. OAM – Oracle Application Manager (OAM) is web based tool to apply oracle apps patch.
.
What happens when you run AutoPatch (adpatch) ?
Depending on patch and your system, adpatch executes some or all of below steps
i) Reads patch metadata to determine patch dependencies and requirements
ii) Uploads patch information from a prior patch session to the database (if applicable)
iii) Reads and validate the patch driver file and reads the product driver files
iv) Compares version numbers of object modules from the product libraries and version numbers of the existing files against the patch files
v) Backs up all existing files that will be changed by the patch under patch directory
vi) Copies files
vii) Archive files in libraries
viii) Relinks executables
ix) Generates forms, reports, messages, graphics, and Java archive (JAR) files.
x) Compiles JSP files and invalid database objects
xi) Updates database objects
xii) Runs AutoConfig to update configuration files if any template files are introduced or updated by the patch
xiii) Saves patch information to the database
.
How to apply AutoPatch (adpatch)
i) Download patch from Metalink
ii) Unzip patch on Server
iii) Shutdown Middle Tier
iv) Enable maintenance mode (using adadmin) or use oprions=hotpatchwith adpatch utility
v) Apply patch using adpatch
vi) Disable maintenance mode (using adadmin)
vii) Start Middle Tier
.
Log file location for AutoPatch (adpatch)
Log files for adpatch are under $APPL_TOP/admin/<SID>/log (for both 11i & R12)
Documentation on Oracle Apps Patching AutoPatch (adpatch)
To learn more about Oracle Apps Patching (adpatch/AutoPatch) follow material (mentioned below) from Oracle
Oracle Guides for Patching
- Patching Procedure in R12
- 11i Oracle Applications Maintenance Procedure -Chapter 3 page 61
- 11i Oracle Applications Maintenance Utilities – Chapter 5 page 81
Metalink Notes for Patching
- 181665.1 Release 11i Adpatch Basics (Must Read)
-
174436.1 Oracle Applications Patching FAQ (Must Read)
- 139684.1 Oracle Applications Current Patchset Comparison Utility – patchsets.sh
- 242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime
- 352843.1 Patch Analysis in OAM
- 756063.1 How to Deal with the adpatch Performance issue : Slow, Hang or Crash