Oracle 19c - Complete checklist for Manual Upgrade for upgrading Oracle 12.x, 18c Container database (CDB) to Oracle 19c (19.x)
(Doc ID 2549866.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 Manual upgrade method 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 Manual Upgrade |
| Upgrade Path / Compatibility Matrix for 19c Oracle Container Database. |
| Step 1: Requirements and Recommendations for source CDB / PDB database. |
| Step 2: Requirements and Recommendations for Target database |
| Known issues |
| Step 3 Preupgrade |
| Step 3.1 Preupgrade script execution |
| Step 3.2 Check for Invalid Objects / Components. |
| Step 3.3 Backing Up Oracle Database For Upgrade. |
| Step 3.4 Verify SYS and SYSTEM default tablespace. |
| Step 3.5 Gathering Optimizer Statistics to Decrease Database Upgrade Downtime |
| Step 3.6 Verifying Materialized View Refreshes are Complete Before Upgrade |
| Step 3.7 Check of TIMESTAMP WITH TIMEZONE Datatype |
| Step 3.8 Ensuring That No Files Are in Backup Mode and no files need media recovery Before Upgrading |
| Step 3.9 Purging Recycle Bin before upgrade |
| Step 3.10 Resolve Outstanding Distributed Transactions Before Upgrading |
| Step 3.11 Starting with Oracle Database 12c release 2 (12.2), you can upgrade the database without disabling Oracle Database Vault. |
| Step 3.12 Back Up Files to Preserve Downgrade and Recovery Options. |
| Step 3.13 Schema-Only Accounts and Upgrading EXPIRED Password Accounts |
| Step 3.14 Copying Transparent Encryption Oracle Wallets |
| Step 3.15 Understanding Password Case Sensitivity and SEC_CASE_SENSITIVE_LOGON parameter |
| Step 3.16 Dependencies on Network Utility Packages |
| Step 3.17 Running Upgrades with Read-Only Tablespaces. |
| Step 3.18 Disable all batch and cron jobs. |
| Step 3.19 Deprecated and Desupported Parameters |
| Step 3.20 Review and Remove any unnecessary hidden/underscore parameters |
| Step 4 Preparing the New Oracle Home for Upgrading |
| Step 5 Upgrade step |
| Step 6 Post-Upgrade steps |
| References |