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

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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

2 comments
Pratheek says June 21, 2014

Dear Atul,

i am working as a oracle apps dba consultant. i have one doubt. while applying a adpatch it is hanged at invalid object compiling phase at the end of the patch. can you please tell me what is the approach to overcome this issue…

Thanks
Pratheek

Reply
Add Your Reply

Not found