ROracle installation :: Unable to load shared obje

Question

• 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.

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"

---

Windows 10, R version 3.2.3

Answer 1

These two steps should fix it for you:

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