Complete Checklist for upgrading Oracle 12.1 Container Database (CDB) to Oracle Database 12c Release 2 (12.2) using DBUA
(Doc ID 2240413.1)
Last updated on JANUARY 08, 2020
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Purpose
The purpose of this article is to perform upgrade of 12.1 container databases (CDB with one or more pluggable databases) using DBUA to 12.2.0.1 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 |
| Database Upgrade Assistant (DBUA) |
| Upgrade Path / Compatibility Matrix for 12.2 Oracle Container 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 |
| Starting with Oracle Database 12c release 2 (12.2), you can upgrade the database without disabling Oracle Database Vault. |
| Drop JSON-Enabled Context search Indexes |
| Copying Transparent Encryption Oracle Wallets |
| Check the accounts use Case-Insensitive password version |
| About Password Case Sensitivity |
| 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 9 of 10) |
| DBUA Step 10 of 10) |
| Post-Upgrade |
| Known Issues |