BookmarkSubscribeRSS Feed
Fluorite | Level 6


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


ERROR: 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.

Opal | Level 21

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:



data _null_;
if sysexist('$ORACLE_HOME') then do;
put "Exists";
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. 


Calcite | Level 5

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



suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 3 in conversation