Oracle EBS R12.2 Online patching via ADOP

Oracle EBS R12.2 Online patching via ADOP

Recently, had an opportunity to attend an interesting session orchestrated by ATG team at Oracle to discuss the new online patching tool (ADOP) in R12.2. Loads of changes to the entire patching process yet mammoth advantages.Here is the brief description.

My understanding is the new ADOP process got 5 phases.

Prepare: Copies the production application code, which in turn creates so called patch edition. During this stage, patch edition and the actual run edition of the file systems are synchronized. It’s in a way easier to sync the patch and run edition. But becomes more complicated during the database’s prepare phase. Even in database, the ADOP process creates a patch version. Here, code objects in the patch edition got just pointers to the actual run edition. Interestingly, none of the storage objects (tables, indexes, etc.) are not copied though.

Apply: In this phase, ADOP applies one or more patches to the copy edition. It executes the patch drivers to the patch edition.

Finalize: This is the final online phase where ADOP process performs tasks such as compile invalid objects, pre-compute DDL to be run. Once this process is completed, the next phase ‘Cutover’ can be scheduled.

Cutover: This is the phase that requires predictable downtime. Here the actual migration of run version to patch version in both file system and database occurs. A restart of middle-tier is required at this stage. Per Oracle, we still are able to perform certain patches in hotpatch mode that doesn’t require downtime. Details to follow upon further hands-on.

Cleanup: Literally clean-up occurs after the users are back online. In this phase ADOP starts cleaning up the old editions to recover space.

ADOP’s Major capabilities are not limited to the following.

  • A patch cycle can be aborted any time before cutover phase.
  • As the new ADOP process maintains a copy of the file system, the size would absolutely double.
  • System and seed tablespaces would now require 100% more space.
  • You can have one instance top to point to multiple environments.

As database edition based patching cycle is significant portion of 12.2’s patching, I will address it as a separate post in coming days.

A special thanks to Oracle’s ATG team.

Prior R12.2 related posting can be found in
Oracle E-Business Suite Release 12.2 Information Center – Implement (Doc ID 1583153.1)

Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID 1531121.1)

Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID 1531121.1)


About Sunthar Tharmalingam
Bio: Sunthar is an Oracle Certified Professional with over 14 years of experience in multifaceted architectural design and implementation of mission-critical global Oracle Applications. He provides technical leadership to the enterprise project teams and manages the comprehensive implementation life-cycle. Sunthar has exhaustive hands-on competencies in vital Oracle technologies such as Oracle E-Business Suite, Databases, OBI Applications, Oracle Identity Management and Webcenter suites. This Blog has been categorized according to the Oracle products that integrates with Oracle E-Business Suite. Should you wish to participate as an author for a related module or category please register as a member and mail me to let me know which category you would like to write under.

2 Responses to Oracle EBS R12.2 Online patching via ADOP

  1. chinna says:

    Hi Sunthar,

    Please share the documets on R12.2 Dual File System.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: