03-30-2016 02:23 PM
We have v9.4 T3 on both PC and Linux Red Hat. We can access Oracle databases running directly from Linux, But the same code doesn't work when remote submitted from PC-SAS via SAS/CONNECT.
1 libname clinmrt oracle user = U0147647 password = XXXXXXX path = '@cadmartp' schema=clinmrt dbindex=no;
NOTE: Libref CLINMRT was successfully assigned as follows:
Physical Name: @cadmartp
Remotely sumitted to Linux vai SAS/CONNECT:
ERROR: Could not load /applications/sas94/sas943home/SASFoundation/9.4/sasexe/sasora (35 images
ERROR: libclntsh.so.11.1: cannot open shared object file: No such file or directory
1 libname clinmrt oracle user = U0147647 password = XXXXXXX path = 'cadmartp' schema=clinmrt
1 ! dbindex=no;
ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not
Please make sure Oracle environment is set correctly.
Look in the install/Config doc for additional info for your platform.
Other possible reasons - incomplete Oracle client install, 32/64-bit mismatch between Oracle
client & SAS, incorrect Oracle client version(Oracle client must match the version
picked during post-install process), incompatible sasora for your OS or its attribs
don't permit SAS to load it.
ERROR: Error in the LIBNAME statement.
03-30-2016 03:01 PM - edited 03-30-2016 03:05 PM
Looks like you missing some Oracle setup stuff via CONNECT signon. I'm guessing that the $ORACLE_HOME environment variable is not being set when you signon hence SAS can't find the Oracle executables - this only applies if you are using SAS/ACCESS to Oracle.
Try using the SYSEXIST SAS function to check this:
if sysexist('$ORACLE_HOME') then do;
Oracle_Home = sysget('$ORACLE_HOME');
put Oracle_Home = ;
else put "Not exists";
You may need to work with your SAS server administrator on this one.
03-30-2016 03:04 PM
In $SAS_HOME/SASFoundation/9.4/bin/sasenv_local add lines like the following:
export ORACLE_BASE=/sas/oracle (point to the base oracle location)
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1 (point to the oracle home)
# library path