Oracle Database 12c to 19c - A step-by-step, cross-server upgrade walkthrough
— 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....
