Please see the steps below:
To use SAS/ACCESS Interface to Oracle, you must set the ORACLE_HOME environment variable.
In addition, you must make sure that the shared library path variable (the name of this variable is
operating system dependent) points to where the Oracle shared libraries are located. This is
required since the SAS/ACCESS Interface to Oracle executable uses Oracle shared libraries and
needs to know where they are located at your site.
If the environment variables are not set correctly, you will see error messages similar to the
following when connecting to Oracle from SAS:
ERROR: Could not load /app/SAS/SASFoundation/9.4/sasexe/sasora (86
images loaded)
ERROR: Could not load module
/app/SAS/SASFoundation/9.4/sasexe/sasora. Dependent module
libclntsh.a(shr.o) could not be loaded.Could not load module
libclntsh.a(shr.o).System error: No such file or directoryCould not
load module /app/SAS/SASFoundation/9.4/sasexe/sasora. Dependent
module /app/SAS/SASFoundation/9.4/sasexe/sasora could not be loaded.
ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded.
ERROR: Image SASORA found but not loadable.
ERROR: Error in the LIBNAME statement.
Source: Configuration Guide for SAS 9.4 Foundation for UNIX Environments