Introduction to Oracle 23c & 23ai: What’s New for Admins

Oracle 23c and 23ai modernize database operations with cloud-first automation, AI-assisted administration, and a secure multitenant core. This lesson orients DBAs who are transitioning from on-prem/legacy toolsets (Universal Installer, DBCA-only thinking, Software Packager) to today’s OCI-centric workflows: automated provisioning, lifecycle management, upgrades, and observability.

Learning Objectives

• Understand the deployment landscape: Autonomous Database, Exadata Cloud, VM DB Systems, and on-prem CDB/PDBs.
• Map legacy “install & configure” steps to modern provision & automate workflows (OCI Console, CLI, Terraform/Resource Manager).
• Know the core 23c/23ai platform themes: multitenant by default, automation (FPP, AutoUpgrade), security-first, and AI-enabled features.

Modern Deployment Models

• Autonomous Database (ADB) — fully managed (provisioning, patching, scaling, backups). Great for analytics, dev/test, and rapid workloads.
• Exadata Cloud/Customer & VM DB Systems — managed infrastructure with DBA control of CDB/PDB layout and parameters.
• Hybrid/On-Prem 23c — use the same multitenant engine with cloud-style automation (Fleet Patching & Provisioning, AutoUpgrade).

Provisioning & Configuration: From “Install” to “Automate”

Replace manual installers with repeatable automation:

1. OCI Console — fast, guided provisioning (networking, storage, backups).
2. OCI CLI & REST APIs — scriptable provisioning and day-2 ops.
3. Terraform & OCI Resource Manager — infrastructure as code for idempotent, versioned deployments.

Examples

Provision via OCI CLI (illustrative):

# Create a DB system (parameters abbreviated)
oci db system launch \
  --compartment-id ocid1.compartment.oc1..aaaa... \
  --availability-domain AD-1 \
  --shape "VM.Standard3.Flex" \
  --db-system-options "{ \"storageManagement\":\"LVM\" }" \
  --display-name "prod-db23c"

Terraform skeleton (illustrative):

provider "oci" {}

module "db_system" {
  source = "oracle-terraform-modules/db-system/oci"
  compartment_ocid = var.compartment_ocid
  db_edition       = "ENTERPRISE_EDITION_EXTREME_PERFORMANCE"
  shape            = "VM.Standard3.Flex"
  cpu_core_count   = 8
}

23c/23ai Platform Themes That Matter to DBAs

• Multitenant by default — CDB with PDBs; per-PDB parameter scoping and isolation; cloning for dev/test.
• Lifecycle automation — Fleet Patching & Provisioning (FPP) for image-based rollout, AutoUpgrade for minimal-downtime upgrades.
• Security first — IAM-integrated access, network segmentation, TDE by default, auditing and secrets management.
• Observability — OCI Database Management, Logging/Events, metrics/alerts; ADB adds auto-tuning/auto-indexing signals.

Parameter Management in 23c (Preview)

Static “init.ora” mindsets give way to policy-driven, dynamic configuration. Use CDB-level ALTER SYSTEM SET with inheritance to PDBs where appropriate, and override at PDB for workload needs. Gather stats with DBMS_STATS; let the CBO and adaptive features pick plans. (Deep-dive in Lesson 3.)

Upgrades & Migrations

• AutoUpgrade orchestrates pre-checks, cutover, and post-fixups for 23c.
• Data Guard and GoldenGate support cross-region, cross-environment moves and near-zero downtime transitions.
• FPP standardizes images across fleets for consistent patch levels.

Backup & Recovery (High Level)

• RMAN integrated with OCI Object Storage; archived redo for PITR.
• ADB automates backups and retention; DB Systems expose RMAN for policy control.

Admin Checklist (Sanity Check)

• Decide target model (ADB vs DB System vs Hybrid).
• Codify provisioning (Terraform/Resource Manager) and store in version control.
• Adopt FPP for patch/clone; standardize base images.
• Enable IAM least-privilege + network segmentation from day one.
• Define backup/PITR objectives; test restores quarterly.
• Turn on metrics/alerts; document SLOs and runbooks.

Next lesson: Understanding Oracle Cloud Provisioning (Console, CLI, Terraform/Resource Manager) and how it replaces legacy installers.