dataiotech Labs
dbaguidedbaguideDBAdataxtoolsdataopsphere
dbaguide.com
Home/Versions/oracle-versioning-scheme
19c - 26aiSürümleme & Yaşam Döngüsü Mimarisi · Long-Term vs Innovation & RU Mimarisi11 min read

Oracle Database Versioning Scheme: Long-Term vs Innovation Releases, Release Updates (RU) & Lifecycle

19c & 26ai Long-Term Stability (23c -> 23ai -> 26ai), 21c Innovation Track, Quarterly Release Updates (RU), and Enterprise Upgrade Paths

Senior DBA Evaluation Matrix
Year-Based Release Numbering & 26ai Evolution

Oracle shifted to year naming post-12c. 23c evolved to 23ai, culminating in the October 2025 policy GA release of Oracle AI Database 26ai (23.26.1 / 26.0.0.0) succeeding 19c.

⚠ 19c represents 12.2.0.3, whereas 26ai LTS represents the modern 23.26.x kernel.
Long-Term vs Innovation Release Classes

Support is release-specific: 19c Premier 2029 / Extended 2032; 26ai Premier 2031 / Extended TBD; 21c Premier July 2027 / no Extended.

⚠ Enterprise data centers should strictly standardize on Long-Term branches (19c and 26ai LTS).
Quarterly Release Updates (RU) Standard

Replaced legacy PSUs and CPUs with quarterly Release Updates (RU) issued in Jan, Apr, Jul, and Oct. 26ai quarterly updates ship as 23.26.x.

⚠ RURs have been sunset; enterprise clusters should maintain a cadence of recent quarterly RUs.

▸1. The Shift to Calendar Year-Based Releases & 26ai

Prior to 2018, Oracle Database shipped monolithic major generations (9i, 10g, 11g, 12c) followed years later by Release 2 (R2) patchsets. In 2018, Oracle restructured this delivery cadence into annual calendar-based releases:

  • •18c (12.2.0.2): The inaugural annual Innovation branch.
  • •19c (12.2.0.3): The terminal Long-Term Release for the 12c line (Premier through December 2029; Extended through December 2032).
  • •21c (21.x): Innovation branch (Premier Support through July 2027; no Extended Support).
  • •Oracle AI Database 26ai (23.26.1 / 26.0.0.0): Oracle renamed 23c to 23ai and subsequently released Oracle AI Database 26ai as the official Long-Term Support (LTS) successor to 19c (Policy GA: October 2025, with quarterly updates numbered 23.26.x).

▸2. Long-Term vs Innovation Release Classifications

Oracle segments releases into two distinct functional classifications:

DimensionLong-Term Release (e.g. 19c, 26ai)Innovation Release (e.g. 18c, 21c)
Premier Support19c: December 2029; 26ai: December 203121c: July 2027; check each release policy
Extended Support19c: December 2032; 26ai: TBDNONE (No extended support offered)
Primary IntentMission-critical production, core banking, ERPEarly adopter evaluation and capability sandboxing
Senior DBA VerdictProduction Mandatory (26ai LTS)Avoid in production clusters

▸3. Release Updates (RU) Patching Architecture

Oracle streamlines database maintenance via Release Updates (RU) issued quarterly (January, April, July, October):

  • •Semantic Notation: 26ai servicing is delivered via quarterly 23.26.x release updates.
  • •Package Contents: Cumulative security alerts (CVE/CPU), optimizer bugfixes, and critical kernel mitigations compiled into a unified binary patch.
  • •Retirement of RURs: Oracle phased out Release Update Revisions (RUR); production maintenance plans must standardize on deploying recent Release Updates directly.

▸4. Enterprise Upgrade Strategy: Direct Migration from 19c to 26ai LTS

Thousands of mission-critical systems operate on Oracle 19c today:

  • •Flawed Approach: Moving to 21c without accounting for its July 2027 Premier Support end and lack of Extended Support.
  • •Production Standard (The Golden Path): Oracle 19c ➔ Oracle AI Database 26ai LTS direct upgrade.
  • •Oracle AutoUpgrade provides official out-of-the-box direct upgrade paths from 19c to 26ai LTS with automated pre-checks.

▸5. SQL Verification of Engine and RU Levels

sql
-- 1. Inspect complete version banner: SELECT banner_full FROM v$version; -- 2. Inspect applied Release Update (RU) inventory: SELECT patch_id, action, status, description FROM dba_registry_sqlpatch ORDER BY action_time DESC;
Back to Versions