Oracle 19c - Complete Checklist for Upgrading to Oracle Database 19c (19.x) using DBUA
(Doc ID 2545064.1)
Last updated on JULY 20, 2024
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 |