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
$ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/188.8.131.52/dbhome_1/rdbms/admin/preupgrade.jar FILE TEXT DIR /u01/preupgradelog