My Oracle Support Banner

Complete checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1.x.x to 12.2..x.x (Doc ID 2173144.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database - Standard Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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 12cR1 multitenant database to higher version 12cR2 (12.2.x.x)

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 CDB / PDB database
 Step 2 Take backup of CDB / PDB database
 Step 3 Check for the integrity of the database
 Step 4 Pre-Upgrade Steps
 Step 4.1 Preupgrade script execution
 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 dbupgdiag.sql
  
References

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