Complete Checklist for Upgrading to Oracle Database 12c Release 2 (12.2) using DBUA
(Doc ID 2189854.1)
Last updated on JULY 08, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.2.0.3 to 12.2.0.1 [Release 11.2 to 12.2]
Oracle Database Backup 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
Information in this document applies to any platform.
Purpose
The purpose of this article is to perform the upgrade of the pre-12c database using DBUA to 12.2.0.1.
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 Database. |
| Requirements and Recommendation for source database. |
| Requirements and Recommendations for Target database |
| Recommendation for Oracle Spatial Component: |
| 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. |
| Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault (For Oracle Database releases earlier than 12.1) |
| Audit Table Preupgrade |
| Running olspreupgrade.sql on Oracle Database Release 11.2 |
| 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) |
| If Oracle Spatial (SDO) is installed, then apply the merge patch 29715479 |
| Desupport of OLAP Catalog (OLAP AMD) (For Oracle Database releases earlier than 12.1) |
| Drop JSON-Enabled Context search Indexes (Only for the upgrade of 12.1 DB to 12.2) |
| 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 2of 9) |
| DBUA (Step 3 of 9) |
| DBUA (Step 4 of 9) |
| DBUA (Step 5 of 9) |
| DBUA (Step 6 of 9) |
| DBUA (step 7 of 9) |
| DBUA (Step 8 of 9) |
| DBUA Step 9 of 9) |
| Post-Upgrade |
| Known Issues |
| References |