Usage Note 11728: SAS 9 of the SAS/ACCESS Interface to Oracle needs an Oracle 64-bit
client installation
The follow error messages may 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, be 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 installation 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 can not be in the setting either because it may cause
problems with some basic UNIX commands, such as vi and more.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | 64-bit Enabled Solaris | 9 TS M0 | |
Solaris | 9 TS M0 | |
Tru64 UNIX | 9 TS M0 | |
64-bit Enabled AIX | 9 TS M0 | |
HP-UX IPF | 9 TS M0 | |
AIX | 9 TS M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> Procedures ==> ACCESS
|
Date Modified: | 2008-07-15 11:24:07 |
Date Created: | 2004-02-03 16:36:55 |