libclntsh.so not found when deploying Oracle RDS driver

[biohazd]

Viya4 Deployment Version Details

• 6.2.0 https://github.com/sassoftware/viya4-iac-aws
• 6.10.0 https://github.com/sassoftware/viya4-deployment
• SAS Viya 4 - 2023.03

Error when trying to connect to Oracle. - ERROR: Unable to load oracle client (libclntsh.so)

I have deployed the Oracle driver files onto an EFS share and it mounts on the CAS nodes

The Environment variables are set:

sh-4.4$ env | grep oracle
LD_LIBRARY_PATH=/access-clients/oracle/instantclient_21_10
ORACLE_BIN=/access-clients/oracle/instantclient_21_10
ORACLE_HOME=/access-clients/oracle/instantclient_21_10
SAS_EXT_LLP_ACCESS=/opt/sas/viya/home/lib64/accessclients/lib::/access-clients/oracle/instantclient_21_10::/opt/sas/viya/home/lib64:::::::::::
SAS_EXT_PATH_ACCESS=:/access-clients/oracle/instantclient_21_10::
ORACLE=/access-clients/oracle/instantclient_21_10
THIRD_PARTY_LIB=/access-clients/oracle/instantclient_21_10

sh-4.4$ ls -al /access-clients/oracle/instantclient_21_10/
total 245660
drwxrwxr-x 3 nobody nobody      6144 Jul 25 09:38 .
drwxrwxr-x 4 nobody nobody      6144 Jul 25 11:07 ..
-rwxr-xr-x 1 nobody nobody     42168 Mar 21 11:41 adrci
-rw-r--r-- 1 nobody nobody      5780 Mar 21 11:41 BASIC_LICENSE
-rw-r--r-- 1 nobody nobody      1633 Mar 21 11:41 BASIC_README
-rwxr-xr-x 1 nobody nobody     59536 Mar 21 11:41 genezi
lrwxrwxrwx 1 nobody nobody        21 Jul 25 09:38 libclntshcore.so -> libclntshcore.so.21.1
lrwxrwxrwx 1 nobody nobody        21 Jul 25 09:38 libclntshcore.so.12.1 -> libclntshcore.so.21.1
lrwxrwxrwx 1 nobody nobody        21 Jul 25 09:38 libclntshcore.so.18.1 -> libclntshcore.so.21.1
lrwxrwxrwx 1 nobody nobody        21 Jul 25 09:38 libclntshcore.so.19.1 -> libclntshcore.so.21.1
lrwxrwxrwx 1 nobody nobody        21 Jul 25 09:38 libclntshcore.so.20.1 -> libclntshcore.so.21.1
-rwxr-xr-x 1 nobody nobody   8108512 Mar 21 11:41 libclntshcore.so.21.1
lrwxrwxrwx 1 nobody nobody        17 Jul 25 09:38 libclntsh.so -> libclntsh.so.21.1
lrwxrwxrwx 1 nobody nobody        17 Jul 25 09:38 libclntsh.so.10.1 -> libclntsh.so.21.1
lrwxrwxrwx 1 nobody nobody        17 Jul 25 09:38 libclntsh.so.11.1 -> libclntsh.so.21.1
lrwxrwxrwx 1 nobody nobody        17 Jul 25 09:38 libclntsh.so.12.1 -> libclntsh.so.21.1
lrwxrwxrwx 1 nobody nobody        17 Jul 25 09:38 libclntsh.so.18.1 -> libclntsh.so.21.1
lrwxrwxrwx 1 nobody nobody        17 Jul 25 09:38 libclntsh.so.19.1 -> libclntsh.so.21.1
lrwxrwxrwx 1 nobody nobody        17 Jul 25 09:38 libclntsh.so.20.1 -> libclntsh.so.21.1
-rwxr-xr-x 1 nobody nobody  83826120 Mar 21 11:41 libclntsh.so.21.1
-rwxr-xr-x 1 nobody nobody   5844064 Mar 21 11:41 libnnz21.so
lrwxrwxrwx 1 nobody nobody        21 Jul 25 09:38 libocci_gcc53.so -> libocci_gcc53.so.21.1
-rwxr-xr-x 1 nobody nobody    956832 Mar 21 11:41 libocci_gcc53.so.21.1
lrwxrwxrwx 1 nobody nobody        15 Jul 25 09:38 libocci.so -> libocci.so.21.1
lrwxrwxrwx 1 nobody nobody        15 Jul 25 09:38 libocci.so.10.1 -> libocci.so.21.1
lrwxrwxrwx 1 nobody nobody        15 Jul 25 09:38 libocci.so.11.1 -> libocci.so.21.1
lrwxrwxrwx 1 nobody nobody        15 Jul 25 09:38 libocci.so.12.1 -> libocci.so.21.1
lrwxrwxrwx 1 nobody nobody        15 Jul 25 09:38 libocci.so.18.1 -> libocci.so.21.1
lrwxrwxrwx 1 nobody nobody        15 Jul 25 09:38 libocci.so.19.1 -> libocci.so.21.1
lrwxrwxrwx 1 nobody nobody        15 Jul 25 09:38 libocci.so.20.1 -> libocci.so.21.1
-rwxr-xr-x 1 nobody nobody   2374520 Mar 21 11:41 libocci.so.21.1
-rwxr-xr-x 1 nobody nobody 142717496 Mar 21 11:41 libociei.so
-r-xr-xr-x 1 nobody nobody    153600 Mar 21 11:41 libocijdbc21.so
-rwxr-xr-x 1 nobody nobody    116160 Mar 21 11:41 liboramysql.so
drwxr-xr-x 3 nobody nobody      6144 Mar 21 11:41 network
-rw-r--r-- 1 nobody nobody   5151563 Mar 21 11:41 ojdbc8.jar
-rw-r--r-- 1 nobody nobody   1803713 Mar 21 11:41 ucp.jar
-rwxr-xr-x 1 nobody nobody    236048 Mar 21 11:41 uidrvci
-rw-r--r-- 1 nobody nobody     31869 Mar 21 11:41 xstreams.jar

if I look in "ldconfig -p", the file libclntsh.so is not shoing there

Ansible Variable File Details

No response

Steps to Reproduce

try use Oracle driver to connect to Oacle RDS

Expected Behavior

it connects and works

Actual Behavior

103  /*Assign the Oracle compute Library if not configured by an Admin account*/
104  libname orademo oracle user="cdsadmin" password=XXXXXXXXXXXXXXXXX
105  path="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP
106  )(HOST = vXXXXXXbx9.eu-west-2.rds.amazonaws.com)(PORT = 1521)) (CONNECT_DATA =
106! (SERVICE_NAME=exadat12c)))" ;
ERROR: Unable to load oracle client (libclntsh.so)
ERROR: Error in the LIBNAME statement.

Additional Context

No response

References

No response

Code of Conduct

• [X] I agree to follow this project's Code of Conduct