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 laterGen 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.
Purpose
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)
Scope
Database Administrators, 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 |
| 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 |
| Performance |
| 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 |
| References |