Oracle 19c - Complete Checklist for Upgrading to Oracle Database 19c (19.x) using DBUA
(Doc ID 2545064.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Purpose
The purpose of this article is to help DBA's / Support Teams to perform the upgrade of a database using DBUA to 19.x.
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 |
| Database Upgrade Assistant (DBUA) |
| About Read-Only Oracle Homes |
| Upgrade Path / Compatibility Matrix for 19.x Oracle Database |
| Requirements and Recommendation for source database |
| Requirements and Recommendations for Target database |
| Prerequisites for Preparing Oracle Home on Windows |
| Pre Upgrade |
| 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 |
| Databases That Use Oracle Label Security and Oracle Database Vault |
| Save OEM DB Control Configuration (For Oracle Database releases earlier than 12.1) |
| Single-instance databases: |
| Oracle Real Application Clusters (Oracle RAC) databases: |
| Removing DB Control with emremove.sql (For Oracle Database releases earlier than 12.1) |
| Desupport of OLAP Catalog (OLAP AMD) (For Oracle Database releases earlier than 12.1) |
| Copying Transparent Encryption Oracle Wallets |
| Check the accounts use Case-Insensitive password version |
| About Password Case Sensitivity |
| Requirement for Upgrading Databases that Use Oracle Warehouse Builder (OWB) |
| Invoke DBUA |
| DBUA ( Step 1 of 9 ) |
| DBUA ( Step 2 of 9 ) |
| DBUA ( Step 3 of 9 ) |
| DBUA ( Step 4 of 9 ) |
| DBUA ( Step 5 of 9 ) |
| DBUA ( Step 7 of 9 ) |
| DBUA ( Step 8 of 9 ) |
| DBUA ( Step 9 of 9 ) |
| Post Upgrade |
| Known Issues |
| References |