My Oracle Support Banner

Complete checklist for 12c R1 PDB upgrade (Upgrading single/multiple Pluggable database (PDB)) (Doc ID 1933391.1)

Last updated on DECEMBER 25, 2019

Applies to:

Oracle Database - Standard Edition - Version to [Release 12.1]
Oracle Database - Enterprise Edition - Version to [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - 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 upgrading 12c PDB to higher version, or higher


 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 Recommendations for source PDB database
 Step 2 Take backup of PDB database
 Step 3 Check for the integrity of the PDB database.
 Step 4 Pre-Upgrade Steps
 Step 4.1 Preupgrade script execution
 Step 4.2 Collect Statistics
 Step 4.3 Verify That Materialized View Refreshes Have Completed Before Upgrading database
 Step 4.4 Ensure That No Files Need Media Recovery Before Upgrading
 Step 4.5 Ensure That No Files Are in Backup Mode Before Upgrading
 Step 4.6 Resolve Outstanding Distributed Transactions Before Upgrading
 Step 4.7 Purge the Database Recycle Bin Before Upgrading
 Step 4.8 Disable all batch and cron jobs
 Step 4.9 Verify SYS and SYSTEM Default tablespace
 Step 4.10 Review and Remove any unnecessary hidden/underscore parameters
 Step 5 Requirements and recommendations for target environment
 Step 6 Upgrade PDB steps
 Step 6.1 Unplug source PDB from CDB
 Step 6.2 Plug PDB into Target CDB
 Step 7 Post upgrade steps
 Step 7.1 Execute post upgrade script
 Step 7.2 Identify Invalid Objects With the utluiobj Script

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