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 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]
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.

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

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.