Precheck utility(preupgrade) for upgrade the Oracle 12c database

Precheck utility(preupgrade) for upgrade the Oracle 12c database

In Installing the new Oracle Home of 12.2 or 12.1, we found the preupgrade.jar file in the RDMBS folder at Oracle Home Location. For running the Preupgrade.jar file for checking the precheck before starting the upgrade process of the Oracle database.

Set the Oracle Home of new version of Oracle database.
Run preupgrade.jar from ORACLE_HOME.

java -jar E:\oracle\12.2.0\dbhome_1\rdbms\admin\preupgrade.jar FILE TEXT DIR E:\upgrade

After run, Preupgrade generated following files at location E:\upgrade folder:

E:\upgrade\preupgrade.log
E:\upgrade\preupgrade_fixups.sql
E:\upgrade\postupgrade_fixups.sql

Note: If you are facing JRE issue so please install JRE software and try the oracle home has java installed at %ORACLE_HOME%\jdk\jre\bin location.

Example of using Oracle Home Java

--Example to upgrade on 12.2 to 18c
C:\Oracle\12.2.0\dbhome\jdk\jre\bin>java -jar C:\Oracle\18.0.0\dbhome\rdbms\admin\preupgrade.jar FILE TEXT DIR C:\upgradelog


--Example to upgrade from 12 to 19c
export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1
$ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/preupgrade.jar FILE TEXT DIR /u01/preupgradelog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.