- Stop Jenkins;
- Find where are sqlplus executable file (usually at $ORACLE_HOME);
- Check if they have proper permissions (chmod 755 *);
Create a global environment variable ORACLE_HOME like this:
export ORACLE_HOME=/oracle/app/oracle/product/12.1.0/dbhome_1/ or export ORACLE_HOME=<your-sqlplus-directory>
Test your environment with: sqlplus -v , should return SQL*Plus version like SQL*Plus: Release 188.8.131.52.0 Production
Use the try to detect ORACLE_HOME option;
Retry your SQL*Plus operation.
Every time I get this error: libsqlplus.so: cannot open shared object file: No such file or directory or SP2-0667: Message file sp1.msb not found
SQL*Plus need its library and its message file to work properly.