When you configure an Oracle wallet to make a TLS connection, the LIBNAME statement might fail with the following error:

ORACLE connection error: ORA-12560: TNS:protocol adapter error.

This error occurs because the Oracle OCI client expects a valid OS user ID to resolve to a database user name. However, the compute pod on SAS Viya uses an internal user ID, which the database cannot resolve.

To work around this issue, set SAS_POD_USES_NSS_WRAPPER to true in the compute pod template, using the following Kubernetes commands:

$ kubectl -n <namespace> patch podtemplate sas-compute-job-config --type=json -p "[\{'op': 'add', 'path': '/template/spec/containers/0/env/-', 'value': {'name': SAS_POD_USES_NSS_WRAPPER, 'value': 'true'}}]"

$ kubectl -n <namespace> patch podtemplate sas-launcher-job-config --type=json -p "[\{'op': 'add', 'path': '/template/spec/containers/0/env/-', 'value': {'name': SAS_POD_USES_NSS_WRAPPER, 'value': 'true'}}]"

Note: This issue is reported for LTS 2024.03.