Oracle Database Upgrade Matrix (Practical & Current)

1. Supported Direct Upgrade Paths (Official & Safe)

✅ = Supported
⚠️ = Supported but not recommended
❌ = Not supported

1.1 Core Upgrade Matrix

Source Version	19c	21c	23ai	26ai
11.2.0.4	✅	❌	❌	❌
12.1.0.2	✅	❌	❌	❌
12.2.0.1	✅	❌	❌	❌
18c	✅	❌	❌	❌
19c	—	⚠️	✅	❌
21c	⚠️	—	✅	❌
23ai	❌	❌	—	✅*

* 23ai → 26ai is NOT a traditional upgrade; it is a release‑update transition.

---

2. Recommended Upgrade Paths (Real‑World Best Practice)

✅ Oracle‑Recommended Enterprise Path

11g / 12c / 18c
        ↓
      19c (Stabilize)
        ↓
      23ai (LTS, Foundation)
        ↓
      26ai (AI‑native)

Why This Path Works

• 19c = last “classic” LTS, extremely stable
• 23ai = first AI‑native LTS, introduces major SQL & engine changes
• 26ai = continuation of 23ai with AI deeply embedded

---

3. What Is NOT Recommended (But Technically Possible)

Path	Why Not Recommended
19c → 21c → 23ai	21c is innovation‑only
19c → 26ai directly	Skips required AI foundation
12c → 23ai	Too many dictionary + optimizer jumps
11g → 23ai	Unsupported, high risk

---

4. Upgrade Method Matrix (How You Upgrade)

Method	When to Use	Versions
AutoUpgrade	Default choice	11g → 23ai
DBUA	Small DBs only	≤19c
Data Pump	Platform change	Any
GoldenGate	Zero‑downtime	19c+
RU Transition	23ai → 26ai	✅

✅ AutoUpgrade is mandatory for serious environments

---

5. CDB / PDB Requirement Matrix

Version	Non‑CDB Allowed	CDB Mandatory
11g	✅	❌
12.1	✅	❌
12.2+	⚠️	❌
19c	⚠️ (deprecated)	✅ (recommended)
23ai	❌	✅
26ai	❌	✅

👉 23ai and beyond = CDB‑only strategy

---

6. RAC & Data Guard Compatibility Matrix

Source	Target	RAC	Data Guard
19c → 23ai	✅	✅
23ai → 26ai	✅	✅
19c → 26ai	❌	❌

✅ Standby must be upgraded in lockstep

---

7. Cloud vs On‑Prem Upgrade Rules

On‑Prem / Exadata

• Full control
• Two‑step upgrade mandatory
• Longer stabilization windows

OCI / Autonomous

• 23ai → 26ai often managed automatically
• Version naming exposed later
• AI features opt‑in

---

8. AI Feature Availability Matrix

Feature	19c	23ai	26ai
Vector Data Type	❌	✅	✅
AI Vector Search	❌	✅	✅
Select AI (NL → SQL)	❌	✅	✅
JSON Duality	❌	✅	✅
AI Agents	❌	❌	✅
RAG Pipelines	❌	⚠️	✅

---

9. One‑Page Executive Upgrade Matrix (Slide‑Ready)

Legacy (11g/12c/18c)
        ↓
     Oracle 19c  ←– Stability Anchor
        ↓
     Oracle 23ai ←– AI Foundation (LTS)
        ↓
     Oracle 26ai ←– AI‑Native Platform

Key Rule:
👉 Never introduce AI features until 23ai is stable.

---

10. Common Interview / Review Question (With Correct Answer)

Q: Can we upgrade from Oracle 19c directly to 26ai?
✅ Correct Answer:

No. Oracle 26ai is a continuation of the 23ai code line. Enterprises should upgrade 19c → 23ai first, stabilize, then transition to 26ai via release update.