# Oracle Database 19c Release Update Gap and Patch Window Calculator

> Source: https://netray.co/tools/oracle-database-19c-release-update-gap-patch-window-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Enter your current and target 19c Release Update to see the gap, the release quarter and an estimated patch window for in-place or out-of-place patching.

## Category

oracle

## Erp

Oracle Database

## Audience

- Oracle DBA
- ERP administrator
- Change manager

## Tool

**Kind:** calculator

**Inputs:**

#### Current RU (number after 19.)

**Key:** cur

**Type:** number

**Default:** 15

**Min:** 3

**Step:** 1

**Help:** From opatch lspatches or DBA_REGISTRY_SQLPATCH. 19.15 = 15.

#### Target RU (number after 19.)

**Key:** tgt

**Type:** number

**Default:** 27

**Min:** 3

**Step:** 1

#### Oracle homes to patch

**Key:** homes

**Type:** number

**Default:** 2

**Min:** 1

**Step:** 1

**Help:** Database home plus Grid Infrastructure home, per node.

#### Minutes per home for OPatch apply

**Key:** opatch_min

**Type:** number

**Default:** 30

**Min:** 5

**Step:** 5

**Unit:** min

#### PDBs (or 1 for a non-CDB)

**Key:** pdbs

**Type:** slider

**Default:** 3

**Min:** 1

**Max:** 50

**Step:** 1

#### Datapatch minutes per PDB

**Key:** dp_min

**Type:** number

**Default:** 10

**Min:** 1

**Step:** 1

**Unit:** min

#### Patching method

**Key:** ooplace

**Type:** select

**Default:** 0

**Options:**

##### In place (patch the running home)

**Value:** 0

##### Out of place (prepare a new patched home)

**Value:** 1

#### Home switch minutes (out of place)

**Key:** switch_min

**Type:** number

**Default:** 15

**Min:** 1

**Step:** 1

**Unit:** min

**Help:** Stop, repoint oratab and the listener, start in the new home.

**Outputs:**

#### Release Updates behind

**Key:** behind

**Expr:** max(0, tgt - cur)

**Format:** integer

**Primary:** true

#### Months behind

**Key:** months

**Expr:** 3 * behind

**Format:** months

#### Current RU release year

**Key:** cur_year

**Expr:** 2019 + floor((cur - 3 + 1) / 4)

**Format:** integer

#### Current RU release quarter (1-4)

**Key:** cur_q

**Expr:** (cur - 2) - 4 * floor((cur - 2) / 4) + 1

**Format:** integer

#### Target RU release year

**Key:** tgt_year

**Expr:** 2019 + floor((tgt - 3 + 1) / 4)

**Format:** integer

#### Target RU release quarter (1-4)

**Key:** tgt_q

**Expr:** (tgt - 2) - 4 * floor((tgt - 2) / 4) + 1

**Format:** integer

#### Estimated patch window

**Key:** window

**Expr:** if(eq(ooplace, 1), switch_min + dp_min * pdbs, homes * opatch_min + dp_min * pdbs)

**Format:** minutes

**Primary:** true

**Description:** In place: homes x OPatch minutes + datapatch per PDB. Out of place: home switch + datapatch per PDB; the new home is built before the window.

**Chart:**

#### Estimated patch window (minutes) vs PDB count

**Type:** line

**X:** pdbs

**From:** 1

**To:** 50

**Steps:** 25

**Series:**

- window

**Disclaimer:** Release quarters assume the quarterly cadence starting with 19.3 in April 2019 (19.4 July 2019, 19.5 October 2019, 19.6 January 2020 and so on). Confirm the patch number and date for your platform in the My Oracle Support note on Database 19 Release Updates and Revisions. Timings are estimates; measure them on a clone.

## Content

**Intro:** This calculator shows how far your Oracle Database 19c home is behind a target Release Update, when each RU was released on the quarterly cadence, and how long the patch window will be for in-place or out-of-place patching with datapatch across your PDBs.

**Sections:**

#### How to use it

**Body:** Read the current RU from opatch lspatches or from SELECT patch_id, action, status, description, action_time FROM dba_registry_sqlpatch ORDER BY action_time. Enter the number after 19., for example 15 for 19.15. Enter the target, the number of Oracle homes to patch (database home and Grid Infrastructure home), your measured OPatch minutes per home, the PDB count and datapatch minutes per PDB. Choose in place or out of place. Out of place means you install and patch a new home ahead of time, so the outage is only the switch plus datapatch. The chart shows how the window grows with PDB count.

**Bullets:**

- RU gap = target - current; months behind = 3 x gap.
- Quarter index = RU - 3; year = 2019 + floor((index + 1) / 4).
- 19.3 = April 2019, 19.15 = April 2022, 19.19 = April 2023, 19.27 = April 2025, 19.29 = October 2025.

#### RUs are cumulative: jump straight to the target

**Body:** Each 19c Release Update contains all fixes from earlier RUs, so moving from 19.15 to 19.27 is one patch, not twelve. Before applying, check that OPatch in the home meets the minimum version listed in the RU readme (download the latest OPatch, patch 6880880, and unzip it into the home). Run the conflict check against your one-off patches: $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./<patch_dir>. One-off patches not included in the target RU must be re-requested for that RU. For Grid Infrastructure use opatchauto as root, which patches the GI and database homes on a node together.

#### Datapatch and how to check the result

**Body:** After the binaries are patched and the database is open, run $ORACLE_HOME/OPatch/datapatch -verbose. It applies the SQL portion to the CDB root, PDB$SEED and every open PDB, so open all PDBs first. Then check DBA_REGISTRY_SQLPATCH for a SUCCESS row for the new RU in each container, run utlrp.sql if invalid objects appear, and compare with opatch lspatches. A home at 19.27 with a registry still showing 19.15 means datapatch did not run or failed; its logs are under $ORACLE_BASE/cfgtoollogs/sqlpatch.

#### Gotchas for ERP databases

**Body:** ERP vendors certify database patch levels separately: E-Business Suite has its own list of required database patches on top of each RU, and JD Edwards and PeopleSoft list supported database releases in the My Oracle Support Certifications tab. Out of place patching needs the listener, oratab, backup scripts and any hard coded ORACLE_HOME paths in ERP scripts updated. Datapatch time grows with the number of PDBs and the size of the RU's SQL changes, so measure it on a clone of production, not on an empty test database.

**Cta:** If you want your team to ask patch inventories and the SQL patch registry questions in plain English across every database on your own servers, we can set that up.

**Faq:**

#### Can I upgrade directly from Oracle 19.15 to 19.27?

**Answer:** Yes. Release Updates are cumulative, so apply the 19.27 RU directly to a 19.15 home after updating OPatch and checking conflicts with your one-off patches. Then run datapatch so the SQL changes reach every container. You do not apply the intermediate RUs.

#### When was each Oracle 19c Release Update released?

**Answer:** RUs follow a quarterly cadence in January, April, July and October. The on-premises base 19.3 shipped in April 2019, 19.4 in July 2019, and so on, which puts 19.27 in April 2025 and 19.29 in October 2025. Confirm patch numbers and any platform delays in the My Oracle Support note listing Database 19 Release Updates.

#### How do I find which 19c RU is installed?

**Answer:** Run $ORACLE_HOME/OPatch/opatch lspatches for the binaries, and query DBA_REGISTRY_SQLPATCH for the SQL level in each container. Both should show the same RU. SELECT banner_full FROM v$version also shows the full version, for example 19.27.0.0.0.

#### Does datapatch need downtime?

**Answer:** Datapatch runs with the database open, and Oracle supports running it with users connected for many RUs, but changes to busy packages can cause waits or invalidations. For ERP databases most teams run it inside the maintenance window with batch stopped. Check the RU readme for any patch that requires a quiet system.

## Search terms

upgrade oracle database from 19.15 to 19.27, oracle database 19c patch list, oracle database 19c latest patch download, oracle database 19c 19.27, oracle 19c 19.19, oracle database 19c 19.29, oracle 19c release update downtime, out of place patching 19c

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json