My Oracle Support Banner

Complete Checklist for Upgrades to 11gR1 Using DBUA (Doc ID 556477.1)

Last updated on OCTOBER 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - 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 for upgrading from Oracle 9i ,Oracle 10gR1, or Oracle 10gR2 to Oracle 11gR1 (11.1) using DBUA also with minimum downtime and errors.

The DBUA automates the upgrade process by performing all of the tasks normally performed manually. There are some steps which can be performed when the database is running. If these steps can be done manually before upgrading using DBUA, the downtime can be minimized.

These instructions are incomplete for migrating an ASM / RAC installations.  Refer to the migration guide for additional information for ASM / RAC installations.

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
 Requirements:
 Checking for Invalid Components and Objects before upgrade
 Collecting Optimizer Statistics 
 
Check for TIMESTAMP WITH TIMEZONE Datatype
 Disable Oracle Database Vault 
 Check for Invalid user accounts or roles 
 
Backing up Enterprise Manager Database Control Data
 Configuring Network ACL's
 
Analyze the database using the Pre-Upgrade Information Tool.
 Starting Upgrade Using  DBUA:
References

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