ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded - ok interactively but not batch

[MarkN1]

I get the error: 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.

Works fine interactively, but no longer when submitted as a batch file.

Worked fine this morning (and for years), but then installed MS Visual Studio and Python.  That seems to have changed some path variable  

• SAS version 9.4 TS 1M6, Windows 10 Enterprise
• In interactive mode (where it continues to work):  %sysget(TNS_ADMIN) returns the correct network location.   ORACLE_HOME, LD_LIBRARY_PATH not defined as system variables.
• I've uninstalled Python, MS Visual Studio, and reinstalled SAS.  Same errors.

First time posting here.   Looked at related posts, but couldn't figure it out.  Much appreciate any help.

[gwootton]

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.

[JosvanderVelden]

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.

[MarkN1]

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.

[SASKiwi · Accepted solution]

Please update your post as answered in that case.