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 12.1.0.2 to 19.3.0.0.0 [Release 12.1 to 19]Information in this document applies to any platform.
Purpose
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.
Scope
DBA, Support
Details
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
| Purpose |
| Scope |
| Details |
| 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 |
| Preupgrade |
| Check for Invalid Objects / Components: |
| Gathering Optimizer Statistics to Decrease Oracle Database Downtime |
| Verifying Materialized View Refreshes are Complete Before Upgrade |
| Check of TIMESTAMP WITH TIMEZONE Datatype |
| 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) |
| References |