4 Upgrading Oracle Database
Oracle provides a comprehensive set of tools for upgrading Oracle Database with minimal downtime and for migrating your applications to the new release.
Caution:
If you retain the old Oracle software, then never start the upgraded database with the old Oracle software. Only start the database with the executables in the new Oracle Database installation.
Topics:
- Backing Up Oracle Database for Upgrading
Use this procedure to back up your existing Oracle Database before you attempt an upgrade. - Upgrading with Parallel Upgrade Utility (catctl.pl and dbupgrade Shell Command)
This section describes how to use the Parallel Upgrade Utility (catctl.pl
) to run manual upgrades using parallel processing, inclusion and exclusion lists, and other features to manage your upgrade. - Upgrading with Oracle Database Upgrade Assistant (DBUA)
Database Upgrade Assistant (DBUA) provides a graphical user interface to guide you through the upgrade of Oracle Database. DBUA works for CDB and non-CDB database systems. - Upgrade Scenarios for Non-CDB Oracle Databases
Review these topics to understand the upgrade scenarios and procedures for non-CDB Oracle Databases - Example of Manual Upgrade of Windows Non-CDB Oracle Database
These examples show the steps to complete preupgrade checks, upgrade, and postupgrade checks for an Oracle Database 11g Release 2 (11.2.0.4) upgrade to Oracle Database 19c. - Manual Upgrade Scenarios for Multitenant Architecture Oracle Databases
To prepare for manual upgrades, review the manual upgrade scenarios and procedures for Oracle Database deployed with multitenant architecture. - Improvements to Data Dictionary Upgrade and Upgrade Status Displays
Oracle Database 12c includes improvements to the upgrade process, and to how upgrade status appears for the upgraded database. - About Dbupgrade Scripts and catupgrd.sql in Earlier Releases of Oracle Database
The function of thecatupgrd.sql
script is replaced by the Parallel Upgrade Utility,catctl.pl
, and thedbupgrade
anddbupgrade.cmd
scripts. - About Transporting and Upgrading a Database (Full Transportable Export/Import)
You can use file-based or nonfile-based modes for transporting data. - Troubleshooting the Upgrade for Oracle Database
Use these troubleshooting tips to address errors or issues that you may encounter while upgrading your database. - Rerunning Upgrades for Oracle Database
Use these options to rerun upgrades. - Restarting the Upgrade from a Specific Phase that Failed Using -p
Use this option to complete an upgrade after fixing errors.