My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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

Purpose

  This document is created for use as a guideline and checklist when upgrading 12c PDB to higher version, 12.1.0.2 or higher

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 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
References

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