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.
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
Metalink Notes for Patching
174436.1 Oracle Applications Patching FAQ (Must Read)
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.