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
2 The SAS System 13:10 Thursday, December 31, 2020
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.
I am getting the above error while connecting to Oracle developer through libname statement using SAS 9.4 32 bit version
Followed below steps upto 2nd and stuck at 3rd point because when i look at bothpaths there is no quotation marks (attached Snapshots)
If you are on a higher version, I believe there could be something else that is causing the issue at your site. Can you confirm you are using the correct oracle client version that is required as per your site release version? You can check this in the system requirements document to confirm the version compatibility.
For SAS 9.4M7
DBMS Products Required:
• Oracle Database 12.1 or later
• Oracle Client 12.1 or later
Notes: Some additional configuration might be required to use the 12c, 18c, or later client. See the
Configuration Guide for SAS 9.4 Foundation for Microsoft Windows for x64 for more
You can also use the Oracle Instant Client with SAS/ACCESS Interface to Oracle. However,
if you find any issues, you should switch to the full Oracle client, which is the only Oracle
client that SAS uses in official tests. SAS Technical Support will only investigate issues that
can be reproduced with the full Oracle client.
For best results, SAS recommends installing the latest patches on the client and server.