topic Re: ERROR - oracle client loading in SAS Programming

ERROR - oracle client loading

scorbett — Tue, 05 Oct 2021 20:42:47 GMT

ERROR: Unable to load oracle client (oci.dll)
ERROR: Error in the LIBNAME statement.

Re: ERROR - oracle client loading

ChrisHemedinger — Tue, 05 Oct 2021 20:44:02 GMT

You haven't shared much detail here. It's possible that your PATH or other environment variables aren't set to find the Oracle client libraries. Usually that's an administrator / config task to set up.

Re: ERROR

SASKiwi — Tue, 05 Oct 2021 20:45:23 GMT

Please post the LIBNAME statement you are using. Despite rumours to the contrary we aren't good at guessing what is in statements based on the errors produced....

Is this a first time error or has it just started happening?

Re: ERROR

scorbett — Wed, 06 Oct 2021 13:47:44 GMT

Has worked before but this is the first time running it on a new computer.

1 libname PHI_RES oracle user=scorbett
2 password=XXXXXXXXXXXXXXXX
3 path=KSPHI
4 schema=PHI_RESEARCH
5 oracle_73_or_above=YES
6 preserve_col_names=YES
7 preserve_tab_names=YES
8 dbindex=NO;
ERROR: Unable to load oracle client (oci.dll)
ERROR: Error in the LIBNAME statement.

Re: ERROR

Kurt_Bremser — Wed, 06 Oct 2021 13:50:05 GMT

So the obvious question first: did you have the Oracle client installed and set up on this new computer?

Re: ERROR - oracle client loading

ChrisHemedinger — Wed, 06 Oct 2021 14:44:58 GMT

Likely causes:

You don't have the Oracle client installed on this machine
or, you have an Oracle client installed but it's maybe the 32-bit version and you're running 64-bit SAS, so you need the 64-bit Oracle client
or, you have the client(s) but the environment PATH variable doesn't have the Oracle paths included so the SAS process cannot find it.
or, a variation on the above, you do have it in the PATH variable but the wrong version (32-bit) is ahead of the one you need (64-bit).

Check your PATH variable here (on Windows):

Go to Start button > Search > Enter Environment > Select Edit the System Environment variables > Click Environment Variables button-> In System variables, find PATH.

Re: ERROR - oracle client loading

scorbett — Wed, 06 Oct 2021 18:57:59 GMT

It appears I have Oracle - OraClient12Home1 and Oracle - OraClient12Home1_32bit. But I need to have _64bit?

Re: ERROR - oracle client loading

ChrisHemedinger — Wed, 06 Oct 2021 19:14:00 GMT

I'm guessing your SAS is 64-bit version. Your Oracle client that SAS loads, which it will find in your PATH, must also be 64-bit.

SAS Tech Support can help. This diagnostic program (run and save the log) can provide a lot of good information to solve it quickly. I'm assuming you're running this with SAS for Windows.

%put Site: &syssite    Release: &sysvlong    System: &sysscp &sysscpl;    %put &sysuserid;
%let SASROOT=%SYSGET(SASROOT);
%put %quote(&SASROOT);
 %macro doit(command);
   filename p pipe &command lrecl=32767;
   data _null_;
   infile p;
   input;
   put _infile_;
   run;
 %mend;

option LS=256;

%doit("set");
 * windows only;
 %doit("dir ""&SASROOT\access\sasexe\sasio*""");
 %doit("reg query ""HKLM\Software\Oracle"" /s");
 %doit("reg query ""HKLM\Software\Wow6432Node\Oracle"" /s");
 %put %quote(%sysget(PATH));

libname oralib oracle user=orauser password=orapass path=orapath;