We are using Oracle Client 11.2.0.1.0 on windows 7 enterprise x64. I am getting the following error message when loading ROracle:
Error in inDL(x, as.logical(local), as.logical(now), ...) :
unable to load shared object 'C:/Program Files/R/R-3.3.2/library/ROracle/libs/x64/ROracle.dll':
LoadLibrary failure: %1 is not a valid Win32 application.
Error: package or namespace load failed for ‘ROracle’
I understand this indicates a x32 version of OCI.dll is being called. I've unistalled R, rtools, and java, reinstalling only the x64 versions. I've set my environmental variables and built only the 64 bit ROracle without issue. I'm at a loss. I also tried doing a 32bit build of ROracle, thinking maybe I wasn't getting the 64 bit client installed...but the build threw a mixed architecture error, so that's not the issue.
any Ideas on where to look next?? I'm hoping it's a user error on my part I'm just not seeing....
my PATH:
C:\Oracle\product\11.2.0\client_1;C:\Oracle\product\11.2.0\client_1\bin;C:\Program Files\R\R-3.3.2\bin\x64;c:\Rtools\mingw_64\bin;c:\Rtools\bin;C:\Program Files\Java\jre1.8.0_111\bin\server;C:\Program Files\Java\jre1.8.0_111\bin;%SystemRoot%;%SystemRoot%\system32;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Git\cmd;C:\ProgramData\Oracle\Java\javapath
THANK YOU!
Kevin
EDIT: This is the install script I am passing around within my facility to facilitate the process, thought others might find it useful. Windows 7 32bit/64 but with only the 32bit client.
filePathofPackage <- "~\\downloads\\ROracle_1.3-1.tar.gz"
if(Sys.getenv("R_ARCH") != "/i386") stop("Process must be run in 32bit version of R")
Sys.setenv(OCI_LIB32 = "C:\\Oracle\\product\\11.2.0\\client_1\\bin")
Sys.setenv(OCI_INC = "C:\\Oracle\\product\\11.2.0\\client_1\\oci\\include")
install.packages(filePathofPackage, repos = NULL, verbose = T, clean = T)