https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929163#M28533 The issue seems to have resolved itself without any intervention on my part and no further restart of my computer. I won't bother speculating how that might happen, but thanks for replying so quickly. Tue, 21 May 2024 15:01:46 GMT MarkN1 2024-05-21T15:01:46Z https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/928884#M28514 <P>I get the error:&nbsp;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.</P><P>&nbsp;</P><P>Works fine interactively, but no longer when submitted as a batch file.</P><P>&nbsp;</P><P>Worked fine this morning (and for years), but then installed MS Visual Studio and Python.&nbsp; That seems to have changed some path variable&nbsp;&nbsp;</P><P>&nbsp;</P><UL><LI>SAS version 9.4 TS 1M6, Windows 10 Enterprise</LI><LI>In interactive mode (where it continues to work):&nbsp; %sysget(TNS_ADMIN) returns the correct network location.&nbsp;&nbsp;&nbsp;ORACLE_HOME, LD_LIBRARY_PATH not defined as system variables.</LI><LI>I've uninstalled Python, MS Visual Studio, and reinstalled SAS.&nbsp; Same errors.</LI></UL><P>First time posting here.&nbsp; &nbsp;Looked at related posts, but couldn't figure it out.&nbsp; Much appreciate any help.</P> Fri, 17 May 2024 22:18:03 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/928884#M28514 MarkN1 2024-05-17T22:18:03Z https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929027#M28520 You may wish to engage SAS Technical Support, as several issues can produce this error. I believe it essentially means that the SAS/ACCESS Interface to Oracle (SASORA) cannot locate or access the installed Oracle client, so you could try reinstalling that. Mon, 20 May 2024 13:42:31 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929027#M28520 gwootton 2024-05-20T13:42:31Z https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929037#M28522 Can you provide details on the execution for the batch process? Is it scheduled using a scheduler? Who is the user for the batch process? etc. Mon, 20 May 2024 14:20:57 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929037#M28522 JosvanderVelden 2024-05-20T14:20:57Z https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929163#M28533 The issue seems to have resolved itself without any intervention on my part and no further restart of my computer. I won't bother speculating how that might happen, but thanks for replying so quickly. Tue, 21 May 2024 15:01:46 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929163#M28533 MarkN1 2024-05-21T15:01:46Z https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929195#M28535 <P>Please update your post as answered in that case.</P> Tue, 21 May 2024 20:12:58 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-The-SAS-ACCESS-Interface-to-ORACLE-cannot-be-loaded-ok/m-p/929195#M28535 SASKiwi 2024-05-21T20:12:58Z