My Oracle Support Banner

Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2) (Doc ID 2173141.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


 This document is created for use as a guideline and checklist when manually upgrading from Oracle 10gR2 (10.2) , Oracle 11gR1 (11.1) or Oracle 11gR2 (11.2) or Oracle 12c Release 1 (12.1) to Oracle 12c Release 2 (12.2)


 Database Administrators, Support


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
 Step 1: Upgrade Path for 12.2 Oracle database
 Minimum version of the database that can be directly upgraded to Oracle 12c Release 2 (12.2)
 Intermediate upgrades needs to be carried for following releases
 Step 2: Requirements and recommendations for source database
 Step3: Requirements and recommendations for target ORACLE_HOME
 Step 4: Check the health of the source database
 Step 5: Pre-upgrade checks
 Clean up database
 Check materialized views
 Checking Time zone settings
 Back up the database
 Ensure no files are in Back up mode before starting the upgrade
 Purge Recycle bin
 Save Oracle EM DB Control Configuration and Data
 Steps to save data
 Manually remove DB control with emremove.sql
 Drop JSON-Enabled Context search Indexes
 Check the accounts use Case-Insensitive password version
 Remove Unified Auditing Schema and Roles
 Put Schema based tablespaces offline during upgrade
 Preserve Downgrade capability
 Audit table preupgrade requirements
 Cluster DB Requirements
 Resolve Outstanding Distributed Transactions Before Upgrade
 Other Checks
 Step 6: Preupgrade step
 Dependencies on Network Utility Packages
 Check Time zone version
 Step7: Upgrade Database to 12.2
 Step 8: Post-upgrade
 Setting Environment variables on Linux and Unix
 Update oratab entries
 Post-upgrade fixup script
 Upgrading Tables Dependent on Oracle-Maintained Types
 Enabling the New Extended Data Type Capability
 Recovery Catalog Upgrade
 Upgrade the Time Zone File Version After Upgrading Oracle Database
 Upgrading Statistics Tables
 Upgrade Externally Authenticated SSL Users
 Install Oracle Text Supplied Knowledge Bases After Upgrading Oracle Database
 Update Oracle Application Express Configuration After Upgrading Oracle Database
 Configure Access Control Lists (ACLs) to External Network Services
 Enabling Oracle Database Vault After Upgrading Oracle Database
 Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
 Known issues

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