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 |