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. From Linux: 1 libname clinmrt oracle user = U0147647 password = XXXXXXX path = '@cadmartp' schema=clinmrt dbindex=no; NOTE: Libref CLINMRT was successfully assigned as follows: Engine: ORACLE Physical Name: @cadmartp Remotely sumitted to Linux vai SAS/CONNECT: ERROR: Could not load /applications/sas94/sas943home/SASFoundation/9.4/sasexe/sasora (35 images loaded) 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 loadable.. 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.
... View more