FAQ : Database Upgrade And Migration
(Doc ID 1352987.1)
Last updated on SEPTEMBER 17, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - 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? |
| 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 |