My Oracle Support Banner

Oracle 19c - Complete Checklist for upgrading Oracle 12c, 18c Container Database (CDB) to Oracle 19c Release using DBUA (Doc ID 2543981.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1 to 19]
Information in this document applies to any platform.


 The purpose of this article is to perform upgrade of 12c, 18c container databases (CDB with one or more pluggable databases) using DBUA to Oracle 19c release.


 DBA, Support


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 About New Autoupgrade utility
 About Database Upgrade Assistant (DBUA)
 Upgrade Path / Compatibility Matrix for 12.2 Oracle Container Database.
 Requirements and recommendations for source database
 Requirements and Recommendations for Target database
 Prerequisites for Preparing Oracle Home on Windows
 Check for Invalid Objects / Components:
 Gathering Optimizer Statistics to Decrease Oracle Database Downtime
 Verifying Materialized View Refreshes are Complete Before Upgrade
 Ensuring That No Files Are in Backup Mode and no files need media recovery Before Upgrading
 Purging Recycle Bin before upgrade
 Starting with Oracle Database 12c release 2 (12.2), you can upgrade the database without disabling Oracle Database Vault.
 Schema-Only Accounts and Upgrading EXPIRED Password Accounts
 Copying Transparent Encryption Oracle Wallets 
 Understanding Password Case Sensitivity  and SEC_CASE_SENSITIVE_LOGON parameter
 Running Upgrades with Read-Only Tablespaces
 Deprecated Parameters and Desupported Parameters
 Invoke DBUA
 DBUA (Step 1 of 10)
 DBUA (Step 2 of 10)
 DBUA (Step 3 of 10)
 DBUA (Step 4 of 10)
 DBUA (Step 5 of 10)
 DBUA (Step 6 of 10)
 DBUA (Step 7 of 10)
 DBUA (Step 8 of 10)
 DBUA (Step 9 of 10)
 DBUA (Step 10 of 10)

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.