My Oracle Support Banner

FAQ : Database Upgrade And Migration (Doc ID 1352987.1)

Last updated on FEBRUARY 06, 2025

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
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

Frequently Asked Questions for Oracle  Database Upgrade/Migration .

Questions and Answers

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
Questions and Answers
 Generic
 What is a database upgrade?
 What Do The Release Numbers Represent?
 What type of upgrades are there?
 What is the recommended method to upgrade the database?
 Is upgrade time dependent on the size of the database ?
 What is direct and indirect upgrade ?
 Can we estimate the time to upgrade the database ?
 Does the presence of various database components affect the time to upgrade a database?
 Which view can be used to see the current/latest status of the database components ?
 What the are the STATUS of the database components ?
 What setting is recommended for the COMPATIBLE database parameter while doing the upgrade?
 Which schema should the AUD$ table exist in while doing the upgrade ?
 Is the database word size changed during the upgrade?
 AutoUpgrade
 About AutoUpgrade tool
 Autoupgrade document and references
 Can we upgrade multiple databases parallely using Autoupgrade Method? 
 Autoupgrade Blog
 DBUA
 Can we use DBUA to upgrade a database across servers?
 Can we invoke the DBUA silently?
 Where does DBUA get the information of the databases available for upgrade?
 What is the location of the DBUA logs?
 Can DBUA be invoked multiple times after a failed DBUA upgrade?
 Is it required to run pre-upgrade steps before starting DBUA?
 Can we run multiple concurrent DBUA sessions from the same Oracle home to upgrade multiple databases ?
 Manual upgrade
 What is manual upgrade ?
 Can catupgrd.sql be run multiple times while doing a manual upgrade?
 Can we upgrade multiple databases parallely using Manual Method?
 Can a database be upgraded with OFFLINE NORMAL and READONLY user created tablespaces in the source database?
 What is the location of the catpugrd.sql log when using manual upgrade?
 Pre and Post upgrade scripts
 What is the Pre-Upgrade Information Tool (utlu<xxx>i.sql)?
 What is the Post-Upgrade Information Tool (utlu<xxx>s.sql)?
 
What is the location of the Pre-Upgrade and Post-Upgrade Information scripts?
 Is it recommended to implement all the recommendations suggested by Pre-Upgrade Information Tool?
 Recommendations
 Is it recommended to apply the latest available patch set and PSU/CPU on the target database before upgrading the source database?
 Is it recommended to remove "hidden" parameters before upgrading?
 Is it recommended to purge the recycle bin objects prior to upgrade?
 Is it recommended to remove the Obsolete/Deprecated Parameters prior to upgrade?
 Is it recommended to gather statistics on the source database prior to upgrade?
 Timezone file version
 What is the requirement for the timezone file for successful upgrade?
References

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