[CAUAJM_W_112597] Unable to find sqlplus in the PATH is being generated during the installation process / create scheme process

Products

• Autosys Workload Automation

Issue/Introduction

Customer has Oracle Instant Client 19.16 installed on RHEL 8.6.   They are getting the following error when trying to create the schema:

Warning:
[CAUAJM_W_112597] Unable to find sqlplus in the PATH "/opt/ora/app/oracle/instantclient_19_16/bin:/opt/ora/app/oracle/instantclient_19_16".

 

sqlplus however is located  in /opt/ora/app/oracle/instantclient_19_16/bin

Environment

Release : 12.0

Component :

Cause

cawa_installer.log showed

2022-08-31 18:16:12,218 [main] DEBUG com.ca.wla.ae.installer.customaction.validate.AEValidateOracleHomeTnsAdmin - /opt/ora/app/oracle/instantclient_19_16/lib/libclntsh.so IS 64 BIT
2022-08-31 18:16:12,218 [main] DEBUG com.ca.wla.ae.installer.util.CommandUtil - Command Env : PATH = /opt/ora/app/oracle/instantclient_19_16/bin:/opt/ora/app/oracle/instantclient_19_16:/usr/xpg4/bin:/opt/ora/app/oracle/instantclient_19_16/:/opt/ora/app/oracle/instantclient_19_16/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/opt/ora/app/oracle/instantclient_19_16:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/xpg4/bin:/opt/ora/app/oracle/instantclient_19_16/:/opt/ora/app/oracle/instantclient_19_16/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/opt/ora/app/oracle/instantclient_19_16:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin
2022-08-31 18:16:12,218 [main] DEBUG com.ca.wla.ae.installer.util.CommandUtil - Command Env : LD_LIBRARY_PATH = /opt/ora/app/oracle/instantclient_19_16/lib:/opt/ora/app/oracle/instantclient_19_16:/opt/ora/app/oracle/instantclient_19_16
2022-08-31 18:16:12,218 [main] DEBUG com.ca.wla.ae.installer.util.CommandUtil - Command Env : ORACLE_HOME = /opt/ora/app/oracle/instantclient_19_16
2022-08-31 18:16:12,227 [main] INFO  com.ca.wla.ae.installer.util.CommandUtil - Read error stream = Error 6 initializing SQL*Plus
2022-08-31 18:16:12,228 [main] INFO  com.ca.wla.ae.installer.util.CommandUtil - Read error stream = SP2-0667: Message file sp1<lang>.msb not found
2022-08-31 18:16:12,228 [main] INFO  com.ca.wla.ae.installer.util.CommandUtil - Read error stream = SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
2022-08-31 18:16:12,228 [main] DEBUG com.ca.wla.ae.installer.util.CommandUtil - RetVal =1
2022-08-31 18:16:12,228 [main] ERROR com.ca.wla.ae.installer.logger.LogHelper - [CAUAJM_W_112597] Unable to find sqlplus in the PATH "/opt/ora/app/oracle/instantclient_19_16/bin:/opt/ora/app/oracle/instantclient_19_16".

 

 

It indicated that  sqlplus was installed but somehow not configured properly. A manual invocation of sqlplus was also causing the similar error.

Resolution

DBA got the sqlplus error sorted out and then the install proceeded fine after