Oracle 19c - Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 19c
(Doc ID 2539778.1)
Last updated on DECEMBER 09, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and laterOracle Database Cloud Exadata Service
Oracle Cloud Infrastructure - Exadata Cloud Service
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine)
Gen 2 Exadata Cloud at Customer
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 11gR2 (11.2) or Oracle 12c Release 1 (12.1) or Oracle 12c Release 2 (12.2) to Oracle 19c Release
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 |
| About New Autoupgrade utility |
| Step 1: Upgrade Path for 19c Oracle database |
| Minimum version of the database that can be directly upgraded to Oracle 19c |
| Intermediate upgrades needs to be carried for following releases |
| Changes in 19c release |
| Step 2: Requirements and recommendations for source database |
| Step3: Requirements and recommendations for target ORACLE_HOME |
| Step 4: Pre-upgrade checks |
| Clean up database |
| Check materialized views |
| Schema-Only Accounts and Upgrading EXPIRED Password Accounts |
| Copying Transparent Encryption Oracle Wallets |
| Understanding Password Case Sensitivity |
| Checking for Accounts Using Case-Insensitive Password Version |
| Running Upgrades with Read-Only Tablespaces |
| Preparing the New Oracle Home for Upgrading |
| Prerequisites for Preparing Oracle Home on Windows |
| Databases That Use Oracle Label Security and Oracle Database Vault |
| Manually remove DB control with emremove.sql |
| Ensure no files are in Back up mode before starting the upgrade |
| Purge Recycle bin |
| Performance |
| Checking Time zone settings |
| About Upgrading Oracle OLAP Data Security Policies |
| Block Change Tracking |
| PUBLIC Synonym AREA |
| Step 5: Preupgrade step |
| Preupgrade fixup script |
| Dependencies on Network Utility Packages |
| Check Time zone version |
| Backing Up Oracle Database for Upgrading |
| Back Up Files to Preserve Downgrade and Recovery Options |
| Step 6: Upgrade Database to 19c |
| Start the upgrade |
| Check upgrade status |
| Recompile INVALID Objects |
| Step 7: Post-upgrade |
| Setting Environment variables on Linux and Unix |
| Update oratab entries |
| Post-upgrade fixup script |
| Create or Migrate Your Password File with ORAPWD |
| Recovery Catalog Upgrade |
| Upgrade the Time Zone File Version After Upgrading Oracle Database |
| Upgrading Statistics Tables |
| References |