How to Download and Run Oracle's Database Pre-Upgrade Utility
Last updated on FEBRUARY 07, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database - Standard Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
One of the first steps that should be taken prior to an Oracle Database Upgrade is determining any issues the upgrade may present to your database.
Oracle Database Pre-Upgrade utility is executed on your existing database, while the database is running (no shutdown required) and provides a list of items which should be reviewed prior to the actual upgrade. Reviewing and making adjustments prior to actual database upgrade will usually reduce down time and can limit problems during the upgrade.
Origin of Script
The pre-upgrade scripts that are available for download below are shipped with each Oracle Database release. The scripts can also be found in the newly installed $ORACLE_HOME/rdbms/admin directory of the version you are planning to upgrade to. Getting a hold of the pre-upgrade script used to mean downloading the entire Oracle Database Release kit, unpacking it, and pulling it out of the admin directory. Allowing access to the script through this method will make the Oracle Database Upgrade planning easier.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms