My Oracle Support Banner

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 later
Oracle 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.