Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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. 

enter image description here


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

like image 583
Dan Avatar asked Oct 31 '22 05:10

Dan


1 Answers

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)
like image 104
Borislav Aymaliev Avatar answered Nov 15 '22 06:11

Borislav Aymaliev