ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not load

Siva_Harish — Thu, 31 Dec 2020 09:02:17 GMT

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.

Hi Folks,

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)

Open the Windows Registry Editor:
1. Select Start ► Run.
2. Enter regedit in the search box.
Navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\App Paths.
Look for the key SAS.EXE. There are two entries under SAS.EXE. Remove the quotation marks from the beginning and end of the paths for both entries.

Re: ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not

AnandVyas — Thu, 31 Dec 2020 10:32:35 GMT

Hi @Siva_Harish

What is the SAS Version you are using? This issue was fixed for 9.4 M1 release.

https://support.sas.com/kb/46/630.html

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.

Ref: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=n1pqpvdzr7uc0jn1o6prnmpwvi9a.htm&locale=en

https://support.sas.com/documentation/installcenter/en/ikfdtnwx6sr/66390/PDF/default/sreq.pdf

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
information.
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.

topic Re: ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not in Administration and Deployment

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not load

Re: ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not