How to Download and Run Oracle's Database Pre-Upgrade Utility (Doc ID 884522.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Goal

IMPORTANT:Be aware that the preupgrade.jar tool is desupported from Oracle Database 21c release onward. AutoUpgrade tool offers same plus enhanced functionality as preupgrade.jar does, it is strongly recommend to use AutoUpgrade instead.

Make sure you always download the most recent version of AutoUpgrade via MOS Note: 2485457.1, it works even for upgrades to release previous to Oracle Database 21c, please use:

java -jar autoupgrade.jar ...

from now on. By using AutoUpgrade you'll benefit from its superior functionality over the previous toolset.

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.

Solution

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