Oracle 19c OCA Certification: The Honest 2026 Guide

If you’re typing “19c OCA” into Google, you’re not alone. Many candidates still use that phrase—yet Oracle changed the program. This guide explains what “19c OCA” maps to now, the exact exams you’ll take, and a practical 8‑week plan to pass—without fluff.

Quick answer (updated September 2025): Oracle no longer awards a separate 19c OCA for database administration. To validate Oracle Database 19c admin skills today, Oracle’s official path is Oracle Database Administration 2019 Certified Professional (OCP), earned by passing two exams: 1Z0‑082 (Administration I) and 1Z0‑083 (Administration II). A separate SQL exam is not required for this OCP.

---

Why 19c still matters in 2025

Oracle Database 19c is the current Long Term Release and remains heavily deployed worldwide. Oracle’s support policy lists Premier Support through December 2029 and Extended Support through December 2032, which is why so many employers still seek 19c‑ready DBAs.

---

So…does “19c OCA” exist?

Short version: No—at least not the way people remember it. Oracle consolidated the DBA track and removed the old “OCA → OCP” split for 19c administration. Instead, you earn one professional credential by passing both admin exams (Admin I + Admin II). That’s why most people who say “19c OCA” actually want the 19c OCP path—and the starting point is 1Z0‑082.

Note: Oracle still offers a Database SQL Certified Associate credential—but that’s a separate SQL certification and not required for the 19c OCP track.

---

The exams you’ll take (and what they prove)

1) 1Z0‑082 — Oracle Database Administration I (“Admin I”)

• Validates core DBA skills for Oracle up to and including 19c: instance architecture, network config, users & privileges, storage, and foundational backup & recovery with RMAN. It’s your springboard to Admin II. (Oracle’s official 2019 DBA FAQ describes Admin I as the foundation exam.)

Preparing for Oracle 19c OCA can feel overwhelming, but practice is the key. To test your knowledge and get exam-ready, check out our detailed Oracle 19c OCA (1Z0-082) Sample Questions & Answers — 2025 Guide

2) 1Z0‑083 — Oracle Database Administration II (“Admin II”)

• Focuses on the day‑to‑day professional DBA skill set: deploy/patch/upgrade, backup & recovery strategy, and multitenant (CDB/PDB) management at depth. Passing Admin II (plus Admin I) earns you the OCP.

Training requirement? Not mandatory. Oracle recommends training (e.g., Administration Workshop, Backup & Recovery, Managing Multitenant), but it’s not required to earn the credential.

---

What 19c topics to master (smart syllabus snapshot)

These areas align to Oracle’s recommended learning for the 19c admin path:

• Core architecture & setup: DB creation, instance & memory structures, parameter management
• Security & user management: roles, privileges, auditing basics
• Storage & space management: tablespaces, segments, ASM basics
• Oracle Net Services: listener, service registration, client connectivity
• RMAN fundamentals → strategies: backups, restores, duplications, failure diagnosis
• Multitenant (CDB/PDB): creation, cloning, plugging/unplugging, backup/recovery nuances
• Lifecycle & maintenance: patching, upgrades, datapatch, opatch, out‑of‑place vs in‑place
• Performance awareness: monitoring health, AWR/ADDM basics (depth grows in Admin II)

---

An 8‑week study plan that respects your nights & weekends

Assumption: ~1–2 hours on weekdays and a longer block on weekends. Adjust pacing as needed.

Week 1 — Architecture & Setup
Spin up a lab (Linux VM + Oracle 19c where available, or a recent XE for practice). Create a database, explore spfiles/pfiles, and learn startup/shutdown scenarios.

Week 2 — Users, Roles, Privileges & Auditing
Design least‑privilege roles, practice schema migrations, and enable basic unified auditing.

Week 3 — Storage & Networking
Create/manage tablespaces, monitor segment growth, configure listener and service registration, test client connections (tnsping/SQL*Plus).

Week 4 — RMAN Foundations
Backups (full/incremental), validate, restore/recover, duplicate to new host. Break things on purpose and fix them.

Week 5 — Multitenant Basics → Intermediate
Create CDB/PDBs, clone PDBs, hot unplug/plug, understand local vs common users and backup nuances.

Week 6 — Patching & Upgrades
Practice out‑of‑place upgrades in a throwaway lab, run datapatch, and validate via registry views.

Week 7 — Admin II Deepening
Design a restore strategy (RTO/RPO), simulate media loss, rehearse disaster steps, and benchmark simple performance tuning routines.

Week 8 — Mock Exams & Final Review
Alternate timed practice with topic sprints; build a one‑page “exam brain map” (commands, views, pitfalls).

Pro tip: Structure every lab as a repeatable script (SQLPlus + shell). That turns practice into muscle memory.

---

Recommended resources (official first)

• Oracle’s 2019 DBA Certification FAQ — spells out the two‑exam path (1Z0‑082 & 1Z0‑083), notes no separate SQL exam requirement, and lists recommended training. Bookmark this as your source of truth.
• Support policy for 19c — confirms 19c is a Long Term Release with Premier Support to Dec 2029 and Extended Support to Dec 2032. Useful context for your résumé and conversations.
• Oracle University learning paths — align coursework to what appears on Admin I/II (Administration Workshop, Managing Multitenant, Backup & Recovery, Deploy/Patch/Upgrade).

Avoid shortcut “brain dumps.” They risk violations and weak real‑world skills. Use legit practice to gauge pacing—not to memorize answers.

---

Exam‑day tips that actually help

• Practice the setup (mic, camera, workspace) if testing online.
• Allocate per‑question time and mark/return—you don’t get bonus points for staying stuck.
• Translate the scenario into a command: “Which view proves X?” or “Which RMAN step comes next?”

---

Common pitfalls (and how to dodge them)

• Treating Multitenant as optional. It’s not—19c lives in CDB/PDB land. Practice day‑to‑day tasks on PDBs.
• Only knowing “backup” not “restore.” Force yourself to recover from datafile loss and controlfile disasters.
• Ignoring upgrades/patching flow. Build a runbook: prechecks → backup → patch/upgrade → datapatch → post‑validation.

---

FAQ