After searching many threads and trying various things I am still having trouble getting ROracle to work. Any help would be appreciated
I have:
- a recent installation with R3.5.1 and RStudio 1.1.463, OCI instant client version 18.3.
- taken care to install only 64bit versions of software on my 64bit machine.
- downloaded and installed Oracle OCI instant client and SDK and set windows environmental paths
- downloaded ROracle 1.3-1.zip directly from Oracle
When running: install.packages("ROracle_1.3-1.zip", repos = NULL)
I get: Installing package into ‘C:/Users/codrin_kruijne/Documents/R/win-library/3.5’
(as ‘lib’ is unspecified)
package ‘ROracle’ successfully unpacked and MD5 sums checked
When loading with: library("ROracle")
I get: Error: package or namespace load failed for ‘ROracle’:
package ‘ROracle’ was installed by an R version with different internals; it needs to be reinstalled for use with this R version
OK so I found I needed to recompile for which I installed RTools latest version 3.5
When running: install.packages("https://cran.r-project.org/src/contrib/ROracle_1.3-1.tar.gz", repos = NULL, type = "source")
I get a compilation error:
===
Installing package into ‘C:/Users/codrin_kruijne/Documents/R/win-library/3.5’
(as ‘lib’ is unspecified)
trying URL 'https://cran.r-project.org/src/contrib/ROracle_1.3-1.tar.gz'
Content type 'application/x-gzip' length 308252 bytes (301 KB)
downloaded 301 KB
* installing *source* package 'ROracle' ...
** package 'ROracle' successfully unpacked and MD5 sums checked
Oracle Client Shared Library 64-bit - 18.3.0.0.0 Operating in Instant Client mode.
found Oracle Client C:\Users\codrin_kruijne\Documents\ROracle\OCIinstantclient_18_3
found Oracle Client include C:\Users\codrin_kruijne\Documents\ROracle\OCIinstantclient_18_3\sdk\include
copying from C:\Users\codrin_kruijne\Documents\ROracle\OCIinstantclient_18_3\sdk\include
** libs
Warning: this package has a non-empty 'configure.win' file,
so building only the main architecture
c:/Rtools/mingw_64/bin/gcc -I"C:/PROGRA~1/R/R-35~1.1/include" -DNDEBUG -I./oci -O2 -Wall -std=gnu99 -mtune=generic -c rodbi.c -o rodbi.o
In file included from rooci.h:75:0,
from rodbi.c:181:
./oci/oci.h:716:20: fatal error: ociver.h: No such file or directory
#include <ociver.h>
^
compilation terminated.
make: *** [C:/PROGRA~1/R/R-35~1.1/etc/x64/Makeconf:208: rodbi.o] Error 1
ERROR: compilation failed for package 'ROracle'
* removing 'C:/Users/codrin_kruijne/Documents/R/win-library/3.5/ROracle'
* restoring previous 'C:/Users/codrin_kruijne/Documents/R/win-library/3.5/ROracle'
In R CMD INSTALL
Warning in install.packages :
installation of package ‘C:/Users/CODRIN~1/AppData/Local/Temp/RtmpWonPbj/downloaded_packages/ROracle_1.3-1.tar.gz’ had non-zero exit status
===
There is a ociver.h file in my sdk include directory of OCI!
I have not been able to figure out what is amiss. Can anybody help a beginner? ***Moderator note (Timo) removed call out to other members who have not jet participated in this thread.*** Thanks!