Transforming Ideas into Innovation with Cloud, AI, and Data

  — RMAN restore + manual catupgrd.sql path. Oracle 19c is the long-running long-term support release of the 12.2 family and, even with the AI Database line (23ai, 26ai) now established as the forward path, it remains the practical landing zone for many enterprises still on 12c. For estates running 12c (12.2.0.1), an upgrade to 19c is no longer optional — it is the entry ticket to ongoing patching, security fixes, and application certifications, and the natural staging point before any later move to 23ai or 26ai. This post walks through a complete, validated upgrade of a single-instance, non-CDB database from 12.2.0.1 on one server to 19.3.0.0 on another, using a full RMAN backup, cross-server restore, and the manual catupgrd.sql path driven by catctl.pl . Every command, every parameter, and every checkpoint shown below is taken from a real end-to-end run. 1. Why upgrade to 19c, and why this path Oracle Database 19c is positioned as the long-term support (LTS) release of the 12....

  Why This Blog Post? Every Oracle DBA eventually faces the same pivotal moment: the database that has loyally served the business for years is sitting on a release whose mainstream support has already lapsed. Oracle 12c (12.2.0.1) is exactly that case — Premier Support ended in November 2020 and Extended/Limited Error Correction support has long since concluded. The natural and most strategic path forward is Oracle Database 19c — the Long-Term Release (LTR) that delivers stability, extended support, and a dependable runway for years to come. In this blog post,  will walk you through the complete journey of upgrading an Oracle 12c (12.2.0.1) database to Oracle 19c using the Database Upgrade Assistant (DBUA) . You'll see exactly what I planned, what I checked, what I executed, and what I verified — based on a real implementation on a multitenant CDB/PDB architecture. Whether you're preparing for your first Oracle upgrade or polishing your runbook for a production cutover, this...