Oracle EBS 12.2 Online Patching (adop) Cycle and Downtime Calculator
This calculator estimates how long an Oracle EBS 12.2 online patching cycle runs from prepare to cleanup, how many minutes of it users actually lose at cutover, and how that compares with applying the same patches in downtime mode. Use it to plan a patching window and to explain to the business why the cycle is long but the outage is short.
Your numbers
Measured from your last cycle on the patch edition.
Your results
Defaults are planning placeholders, not Oracle figures. Replace them with phase times from adop -status -detail for your last cycle. The merge factor is an assumption. Downtime mode is only allowed where the patch README or Oracle Support permits it.
User downtime vs number of patches
Sweeps Number of patches from 1 to 40, holding your other inputs fixed.
Send us your adop -status output
We will turn your last cycles into measured phase times and a realistic patching window for the next one.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the number of patches in the cycle and the average apply time per patch, then the duration of each adop phase. The best source is your own history: adop -status -detail prints start and end times per phase and node, and AD_ADOP_SESSIONS records the status of each phase per session. Split cutover into stopping services, the file system and edition switch, and starting services, because start time on a multi-node system is often the largest part. The downtime-mode overhead is the time to stop and restart services around a downtime-mode apply.
- Primary output: user downtime with online patching (cutover only).
- Second primary: minutes of downtime avoided compared with downtime mode.
- The chart sweeps the number of patches from 1 to 40.
The model behind the numbers
In 12.2 online patching, prepare synchronises the patch file system and creates the patch edition, apply runs the patches against the patch edition while users work on the run edition, finalize readies the system for cutover, cutover stops services, switches file systems and editions and restarts services, and cleanup removes obsolete objects. Oracle's Maintenance Guide describes cutover as the only phase that requires downtime, and cleanup can run after users are back. So the calculator treats online downtime as stop + switch + start, independent of the number of patches, while downtime mode costs the stop/start overhead plus the full apply time. Formulas: apply = patches x average x (0.7 if merged, else 1); cycle hours = (prepare + apply + finalize + cutover + cleanup) / 60.
Worked example
With the defaults (5 patches at 20 minutes, no merge, prepare 45, finalize 20, cutover 10 + 10 + 15, cleanup 30), apply takes 100 minutes and the full cycle runs about 3.8 hours, but users lose only 35 minutes at cutover. Applying the same five patches in downtime mode would cost 125 minutes of outage, so online patching avoids 90 minutes, and its outage is 28% of downtime mode. At 20 patches the cycle is about 8.8 hours, the cutover stays at 35 minutes in this model, and downtime mode would need 425 minutes.
Gotchas that change the numbers
Cutover is not truly constant: a cutover that has to run outstanding finalize work, many cross-edition triggers or a slow managed-server start on many nodes takes longer, so measure it per cycle. Prepare can be much longer after a large previous cycle because fs_clone or file synchronisation has more to copy. Cleanup in full mode after many patches can run for hours, which matters if you want to start another cycle the same day. Some patches, such as certain AD and TXK delta updates or the initial technology stack patches, require specific modes or hotpatch handling described in their README, and downtime mode is only for patches that permit it.
Frequently Asked Questions
What are the adop phases in Oracle EBS 12.2?
Prepare, apply, finalize, cutover and cleanup, with abort available before cutover to discard the patch edition. Users keep working on the run edition through prepare, apply and finalize; cutover is the outage, during which services stop, the patch file system and edition become the run ones, and services restart. Cleanup removes old editions and objects after users return.
How do I apply a patch in Oracle EBS 12.2?
Run adop phase=prepare, then adop phase=apply patches=<number> (comma list or a merged patch), then adop phase=finalize, adop phase=cutover and adop phase=cleanup, checking adop -status between phases. Read each patch README first: some require downtime mode (apply_mode=downtime) or hotpatch, and AD or TXK updates may have their own sequence.
How much downtime does online patching save?
It depends on how much apply time you move out of the outage. With online patching the outage is roughly the cutover duration, typically tens of minutes on a well-tuned system, while downtime mode costs the full apply time plus stop and start. The more patches in a cycle, the bigger the saving, which this calculator's chart shows.
Should I merge patches before applying them in 12.2?
Merging related patches with admrgpch usually shortens apply because common steps such as relinking, generation and driver processing run once. The 30% reduction in this tool is a planning assumption, not an Oracle figure. Check that every patch's README allows merging and test the merged patch in a clone, then use the measured time in the calculator.
If your DBAs want to ask how long the last cycles took and what is pending in plain English, answered from your EBS AD tables on your own servers, we can set that up.
Related Tools
Oracle EBS Patching Checklist for adop
Step through a full adop patching cycle with pre-checks, the five phases and post-patch validation.
OracleOracle EBS Patch Level, Applied Patches and Version SQL Generator
Generate the queries to find the EBS release, whether bugs are applied, recent patch runs, adop session status, 12.2 code levels and product patch levels.
OracleOracle EBS Maintenance Window and Backup Time Calculator
Work out how long the outage needs to be, including a backup, the work itself, validation and a contingency buffer, and how long a rollback restore would take.
OracleOracle EBS 12.2 Upgrade Readiness Checklist
Check whether your EBS environment, custom code and team are ready to move to Release 12.2 and what to settle before the project starts.
More Oracle tools
See all- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS Inventory Accuracy Readiness Assessment
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Period Close Checklist
- Oracle EBS AP Invoice Interface Template
Keep exploring
Free tools
- Oracle EBS 12.2 adop Phases and Options ReferenceEvery adop phase, apply mode and common option in EBS 12.2 online patching, with example commands, whether it needs downtime and the traps to avoid.
- Oracle EBS Patch Level, Applied Patches and Version SQL GeneratorGenerate the queries to find the EBS release, whether bugs are applied, recent patch runs, adop session status, 12.2 code levels and product patch levels.
- Oracle EBS Patching Checklist for adopStep through a full adop patching cycle with pre-checks, the five phases and post-patch validation.
ERP fixes and how-tos
- Fix adop phase=prepare Failures in EBS 12.2 Online Patchingadop phase=prepare failing in EBS 12.2 usually means the patch and run file systems are out of sync, or a prior cycle did not finish. Resync with fs_clone.
- How the adop Patching Cycle Works in Oracle EBS 12.2How the adop online patching cycle works in Oracle EBS 12.2: prepare, apply, finalize, cutover and cleanup phases across the dual fs1/fs2 file system.
- How to Add a Private AI Layer to Oracle EBS 12.2 On-PremReference architecture for a private AI layer on Oracle EBS 12.2: Active Data Guard replica, ISG REST, MO and responsibility security, local GPUs and audit.
Runs with your ERP
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
AI on your ERP
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
- AI for Oracle EBS in Aerospace and Defense ManufacturingAI on Oracle EBS for aerospace and defense manufacturers: project manufacturing, serial control, and ITAR segregation handled without a cloud dependency.
Integrations
- How to add WhatsApp to Oracle E-Business SuiteHow to connect WhatsApp Business to Oracle E-Business Suite 12.1 and 12.2: ISG REST, Workflow business events, template messages and two-way replies into EBS.
- How to add Slack alerts and approvals to Oracle E-Business SuiteConnect Slack to Oracle E-Business Suite for alerts, slash commands and interactive approvals using Workflow events, Oracle Alert and ISG, without exposing EBS.