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 MAY 07, 2024
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
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 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 |