SAS 9 of the SAS/ACCESS Interface to Oracle needs an Oracle 64-bit client installation


The following error messages might be issued when running SAS 9 of the
SAS/ACCESS Interface to Oracle, and not using an Oracle 64-bit client
release.

  Could not load /opt/sas/sas90/SAS_9.00/sasexe/sasora (63 images
          loaded)
  Error: ld.so.1: /opt/sas/sas90/SAS_9.00/sasexe/sas:
  fatal: /opt/oracle/product/8.1.7/lib/libclntsh.so.8.0: wrong ELF
          class: ELFCLASS32
  ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded.
  ERROR: Image SASORA       found but not loadable.
  ERROR: A Connection to the ORACLE DBMS is not currently supported, or
          is not installed at your site.

 -OR-

  Could not load /tools/sas91/sasexe/sasora (37 images loaded)
  Error: ld.so.1: ./sasexe/sas: fatal: libclntsh.so.9.0: open failed:
         No such file or directory
  ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded.
  ERROR: Image SASORA found but not loadable.
  ERROR: A Connection to the oracle DBMS is not currently supported, or
  is not installed at your site.


To resolve this problem, make sure that you set your shared library path
to point the Oracle 64-bit Client installation.

HPUX:  SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:$SHLIB_PATH

AIXR:  LIBPATH=$ORACLE_HOME/lib:/usr/lib:/lib:$LIBPATH

SOL2, TRU64, LINUX:

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/ucblib:/usr:/lib:$LD_LIBRARY_PATH

-or-LD_LIBRARY_PATH_64=$ORACLE_HOME/lib:/usr/ucblib:/usr:/lib:$LD_LIBRARY_PA
TH

Note: In some Oracle installations, the $ORACLE_HOME/lib may be
referenced as $ORACLE_HOME/lib64 instead, so be sure you are pointing to the 64-bit installation. Also, on some systems the /usr/ucblib cannot be in the setting either because it might cause problems with some basic UNIX commands, such as vi and more.