My Oracle Support Banner

Complete Checklist for Upgrading to Oracle Database 12c Release 1 using DBUA (Doc ID 1516557.1)

Last updated on MAY 02, 2024

Applies to:

Oracle Database - Standard Edition - Version 10.2.0.5 to 12.1.0.2 [Release 10.2 to 12.1]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The purpose of this article is to minimize the downtime while upgrading the database using DBUA.

Database Upgrade Assistant (DBUA) interactively steps you through the upgrade process and configures the database for the new Oracle Database release.

DBUA automates the upgrade process by performing all of the tasks normally performed manually. DBUA makes appropriate recommendations for configuration options such

as tablespaces and redo logs. You can then act on these recommendations. DBUA provides support for Oracle Real Application Clusters (Oracle RAC).

In an Oracle RAC environment, DBUA upgrades all the database and configuration files on all nodes in the cluster.

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
 Database Upgrade Assistant (DBUA)
 Various steps performed by DBUA
 Recommendations for Source database
 Requirements and Recommendations for Target database 
 Compatibility Matrix 
 Run the Pre-Upgrade Information Tool for Collecting Pre-Upgrade Information
 Step 1:
 Step 2:
 The sections which follow describe the output of the Upgrade Information Tool.
 Check for INVALID database components and objects in the Source database
 Check for TIMESTAMP WITH TIMEZONE Datatype
 Disable Oracle Database Vault
 Enterprise Manager Database Control
 Oracle Label Security
 Running olspreupgrade.sql on Oracle Database Release 11.1.0.7
 Running olspreupgrade.sql on Oracle Database Release 10.2.0.5 or 11.2
 Oracle Warehouse Builder
  Check XDB ACLs has start_date and end_date ACE attributes
 Invoke DBUA
 Post Upgrade steps
 Known Issue
References

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