My Oracle Support Banner

Oracle 19c - Complete Checklist for upgrading Oracle 12c, 18c Container Database (CDB) to Oracle 19c Release using DBUA (Doc ID 2543981.1)

Last updated on OCTOBER 23, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.3.0.0.0 [Release 12.1 to 18]
Information in this document applies to any platform.

Purpose

 The purpose of this article is to perform upgrade of 12c, 18c container databases (CDB with one or more pluggable databases) using DBUA to Oracle 19c release.

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
 About Database Upgrade Assistant (DBUA)
 Upgrade Path / Compatibility Matrix for 12.2 Oracle Container Database.
 Requirements and recommendations for source database
 Requirements and Recommendations for Target database
 Prerequisites for Preparing Oracle Home on Windows
 Preupgrade
 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.
 Schema-Only Accounts and Upgrading EXPIRED Password Accounts
 Copying Transparent Encryption Oracle Wallets 
 Understanding Password Case Sensitivity  and SEC_CASE_SENSITIVE_LOGON parameter
 Running Upgrades with Read-Only Tablespaces
 Deprecated Parameters and Desupported Parameters
 Invoke DBUA
 DBUA (Step 1 of 10)
 DBUA (Step 2 of 10)
 DBUA (Step 3 of 10)
 DBUA (Step 4 of 10)
 DBUA (Step 5 of 10)
 DBUA (Step 6 of 10)
 DBUA (Step 7 of 10)
 DBUA (Step 8 of 10)
 DBUA (Step 9 of 10)
 DBUA (Step 10 of 10)
 

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