My Oracle Support Banner

Oracle 19c - Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 19c (Doc ID 2539778.1)

Last updated on JULY 10, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 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 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

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