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 |