5
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

bathyscapher
  • 1,615
  • 1
  • 13
  • 18
Dan
  • 1,711
  • 2
  • 24
  • 39
  • Does `C:/Users/Daniel/R/winlibrary/3.2/ROracle/libs/x64/ROracle.dll` exist? – Bob Jarvis - Слава Україні Apr 22 '16 at 20:48
  • It does. ROracle.dll is the only file in that directory. I checked the path and it's correct. – Dan Apr 22 '16 at 20:56
  • 1
    Having only done this installation once or twice on Windows, all I can suggest is that I recall having to be careful about installing and running either all 32-bit or all 64-bit versions of all pieces, from the Oracle InstantClient, down to R. Just based on your error messages, it seems possible you could be mixing/matching those flavors. – joran Apr 22 '16 at 21:28
  • Thanks @joran. I believe I've triple-checked all components to make sure they're all 64-bit but in case I don't get any solutions here I'll make sure to start from zero with that in min. – Dan Apr 22 '16 at 21:54
  • 2
    @Dan did you manage to solve the problem? If so, could you share your solution? – runr Apr 10 '17 at 07:21

2 Answers2

4

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)
Borislav Aymaliev
  • 803
  • 2
  • 9
  • 20
0

try to run RStudio with administration privilege, I solved this problem with it.

chuang shi
  • 46
  • 4