Datapatch verbose fails with /usr/bin/ksh: No such file or directory (Doc ID 2331571.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

Installing Database Patch Set Update 12.1.0.2.170814 (26609783) with opatch apply succeeds.

However when trying to load modified SQL in the database the ./datapatch -verbose fails with /usr/bin/ksh: No such file or directory

The SQLPATCH invocation logs show below error

[]/refresh/home> tail -f sqlpatch_invocation.log

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
catcon: ALL catcon-related output will be written to /refresh/home/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6082_2017_10_07_20_18_53/sqlpatch_catcon__catcon_6082.lst
catcon: See /refresh/home/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6082_2017_10_07_20_18_53/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /refresh/home/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6082_2017_10_07_20_18_53/sqlpatch_catcon__*.lst files for spool files, if any
/usr/bin/ksh: No such file or directory

Changes

 Applying Database Patch Set Update 12.1.0.2.170814 (26609783)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.