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

Last updated on SEPTEMBER 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.4 and later
Oracle Database - Standard Edition - Version 9.2.0.4 and later
Information in this document applies to any platform.

Goal

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms