[SOLVED] ROracle installation: Unable to load shared object error

ROracle installation: Unable to load shared object error

I need to connect R to an Oracle database
Followed the instructions on https://cran.r-project.org/web/packages/ROracle/INSTALL, exactly, step by step
Getting the following error:

library('ROracle')
Error in inDL(x, as.logical(local), as.logical(now), ...) :
    unable to load shared object 'C:/Users/Daniel/R/winlibrary/3.2/ROracle/libs/x64/ROracle.dll':
    LoadLibrary failure:  %1 is not a valid Win32 application.

I don't know where to start fixing this. Here's the results of libPath():

> .libPaths()
"C:/Users/Daniel/R/win-library/3.2"  "C:/Program Files/R/R-3.2.3```

library('ROracle') /library"

Windows 10, R version 3.2.3

Solution

These two steps should fix it for you:

Rename your "Path" environmental variable to "PATH"
Install the ROracle package only after you have set the Oracle Instant Client in environmental variables. (Just run install.packages() again)