Explain EBS Patching Strategy: AD Utilities and Online Patching in Oracle Applications

55 / 60

Adminadvanced

EBS Patching Strategy: AD Utilities and Online Patching

Explain the EBS patching toolset and how R12.2's Online Patching (ADOP) minimizes downtime

EBS patching relies on the AD (Applications DBA) utilities — adpatch (traditional patch application, requiring downtime for the patched components), adadmin (administrative maintenance tasks like relinking executables, compiling flexfields, or maintaining snapshot information), and, since R12.2, adop (AD Online Patching), which fundamentally changed the patching model by leveraging Oracle Database's Edition-Based Redefinition (EBR) to apply patches to a separate, offline 'patch edition' of the file system and database objects while the 'run edition' continues serving live users, then performing a brief cutover to switch.

Online Patching with adop is like renovating a restaurant's kitchen in a completely separate space while the current kitchen keeps serving customers normally, and then — once the new kitchen is fully ready and tested — briefly closing for just a few minutes to swap operations over, rather than closing the whole restaurant for a multi-day renovation.

Key Concepts

The adop patching cycle has distinct phases: prepare (sets up the patch edition), apply (applies the actual patch to the patch edition, the longest-running phase, occurring without user downtime), finalize (final preparation steps), cutover (the brief actual downtime window where the patch edition becomes the new run edition — typically minutes, not hours), and cleanup (removing the old edition's now-obsolete objects). This reduced planned downtime from potentially many hours (pre-R12.2) to typically just minutes for the cutover phase.

prepareapplyfinalizecutovercleanup

adadmin remains essential for various maintenance tasks outside the patch cycle itself — compiling invalid objects, maintaining the AD_ZD (zero-downtime) tables, relinking application executables after OS/library changes, and generating applications files. Understanding when to use adpatch/adop versus adadmin for a given maintenance task is a foundational EBS DBA/technical skill.

adadminadpatchadop

Interviewers commonly ask candidates to explain the adop phase sequence and why R12.2's online patching represents such a significant operational improvement over prior release patching approaches, testing understanding of both the technical mechanism (EBR) and its practical business benefit (reduced downtime windows).