My Oracle Support Banner

Complete checklist for manual Container database upgrade from 12.1.0.1 to 12.1.0.N (Full CDB Upgrade) (Doc ID 1932762.1)

Last updated on FEBRUARY 14, 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 multitenant database 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 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 Preparing new oracle home for upgrading
 Step 7 Upgrade steps
 Step 8 Post-Upgrade steps
 Step 8.1 Execute post-upgrade script
 Step 8.2 Environment Variables and oratab file
 Step 8.3 Initialization parameter file
 Step 8.4 Upgrade recovery catalog after upgrading database
 Step 8.5 Upgrade timezone after database upgrade
 Step 8.6 Statistics tables created by the DBMS_STATS package
 Step 8.7 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.