My Oracle Support Banner

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

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database - Standard Edition - Version and later
Information in this document applies to any platform.


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.


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
 Origin of Script
 Script Guidelines
 Download and installation Instructions
 See the table below to determine which version of the pre-upgrade script you need.  It will depend on which version you are upgrading from, and which version you are upgrading to.
 Script Execution Steps

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