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:


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/
$ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/ FILE TEXT DIR /u01/preupgradelog

Leave a Reply

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

You are commenting using your 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.