In earlier SAS Viya releases than SAS^® Viya^® 4.0, additional configuration is required to enable connections to Oracle that use Transport Layer Security (TLS), also referred to as Secure Sockets Layer (SSL). If you do not do this configuration, you might see errors that are similar to the following:

To configure SAS Viya as needed, follow these instructions:

1. Ensure that your Oracle client supports TLS by connecting to Oracle via your Oracle client (for example, using sqlplus).
2. Ensure that you complete the steps in Configure SAS/ACCESS Interface to Oracle in SAS^® Viya^® 3.5 for Linux: Deployment Guide. Refer to the SAS^® Viya^® 3.4 documentation, if appropriate.

For your SPRE host, take these steps:

3. In the !SASHOME/spre/home/SASFoundation/sasexe directory, back up the existing sasora file with this command: mv sasora sasora.bak
4. In the same location, create a symbolic link to the appropriate orlax* file for your Oracle client. For example, for Oracle 12.2 and later, use this command: ln -s orlax122 sasora
5. In the !SASHOME/viya/home/SASFoundation/sasexe directory, back up the tkeora.so file with this command: mv tkeora.so tkeora.bak
6. In the same location, create a symbolic link to the appropriate tkeora* file for your Oracle client. For example, for Oracle 12 and later, use this command: ln -s tkeora12.so tkeora.so 

For each CAS node, take these steps:

7. On each CAS node, go to the !SASHOME/spre/home/SASFoundation/sasexe directory and back up the tkeora.so file with this command: mv tkeora.so tkeora.bak
8. In the same location, create a symbolic link to the appropriate tkeora* file for your Oracle client. For example, for Oracle 12 and later, use this command: ln -s tkeora12.so tkeora.so 

If the problem is not resolved, open a track with SAS Technical Support. Include the outputs from the following commands, which assume that your SASHOME directory is /opt/sas and that your Oracle client is installed in /usr/lib/oracle/12.2/:

For configuration information for SAS^® Foundation, see SAS Note 60895, “Under Linux, an Oracle connection using the Oracle 12CR2 client fails with '..ERROR: Image SASORA found but not loadable.'”

Operating System and Release Information