Preupgrade command Fails with:"ERROR - Unable to run sqlplus due to:" (Doc ID 2246672.1)

 

[oracle@oraerptest19c bin]$ pwd

/u02/app/oracle/product/11.2.0/dbhome_1/jdk/bin

[oracle@oraerptest19c bin]$ /u02/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u02/softw-ora19c/rdbms/admin/preupgrade.jar FILE DIR /u02/preupgrade/

ERROR - Unable to run preupgrade due to: 

ERROR - the following error has been found: java.io.IOException: sqlplus: not found

Solution:

======

[oracle@oraerptest19c bin]$ export PATH=.:$ORACLE_HOME/bin:$PATH

[oracle@oraerptest19c bin]$ /u02/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u02/softw-ora19c/rdbms/admin/preupgrade.jar FILE DIR /u02/preupgrade/

==================

PREUPGRADE SUMMARY

==================

  /u02/preupgrade/preupgrade.log

  /u02/preupgrade/preupgrade_fixups.sql

  /u02/preupgrade/postupgrade_fixups.sql

Execute fixup scripts as indicated below:

Before upgrade:

Log into the database and execute the preupgrade fixups

@/u02/preupgrade/preupgrade_fixups.sql

After the upgrade:

Log into the database and execute the postupgrade fixups

@/u02/preupgrade/postupgrade_fixups.sql

Preupgrade complete: 2021-01-16T13:24:52

[oracle@oraerptest19c bin]$