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 laterOracle 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 |