New preupgrade.jar and changes in MOS Note:884522.1

We read and listen to your comments. And that’s why my team mate Byron has added a new preupgrade.jar and changes to MOS Note:884522.1. One reader commented that MOS Note:884522.1 (How to Download and Run Oracle’s Database Pre-Upgrade Utility) does not explain how to “run” the preupgrade tool even though it mentions this in the note’s title.

New preupgrade.jar and changes in MOS Note:884522.1

With MOS Note:884522.1 you can download always the most recent versions of the Oracle 18c and 12.2 preupgrade.jar tools, of the Oracle 12.1.0.2 preupgrd.sql and utluppkg.sql. And you’ll even find the last utlu112i.sql for upgrades to Oracle 11.2.0.4.

You should always download the most recent version of the preupgrade tool for your database version from MOS Note:884522.1. The version you get with a patch set or base release is usually much older than the version you can download as the installed default version has been built before a code freeze date. But the version available on MOS gets updated usually every other month.

New and improved instructions

Based on customer’s feedback Byron has adjusted the instructions to make it more clear on how to use each tool – and added links to the respective documentation pages. This way you’ll find now the correct information on how to use the tool for each version.

Download Instructions

See the table in MOS Note:884522.1 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.

For upgrade-to version 12.1.*, save the zipfile to a directory that will be accessible when you connect to your upgrade-from database and then unzip the file.

If the upgrade-to version is 12.2 or higher, then save the file to your target $ORACLE_HOME/rdbms/admin directory and then unzip the file. It could be your source or target $ORACLE_HOME.

And finally, for upgrade-to version 11.2.0.4 or earlier, copy all of the download files to some directory that will be accessible when you connect to your upgrade-from database.

Script Execution Steps

To execute the preupgrade tool itself, see the Database Upgrade Guide for your upgrade-to version:

• 11.2. databases see: Upgrade guide to 11.2
• 12.1 databases see: Upgrade guide to 12.1
• 12.2 databases see: Upgrade guide to 12.2
• 18c database see: Upgrade guide to 18c

Further Information

For a complete list of preupgrade checks execute by each tool see:

• List of PREUPGRADE checks executed by preupgrade.jar

–Mike