Problem of Installing ROracle 1.3.2 on R 3.6.1 on win 10

Ken20200117

Hello,

I have problems of installing ROracle 1.3.2 on R 3.6.1 on win 10

Please teach me how to fix. Thanks a lot.

Below is the detail.

Ken

=====================================================

Below is the detail

> install.packages("ROracle")

Installing package into ‘C:/Users/kenliu/Documents/R/win-library/3.6’

(as ‘lib’ is unspecified)

Package which is only available in source form, and may need compilation of

  C/C++/Fortran: ‘ROracle’

installing the source package ‘ROracle’

trying URL 'https://cran.rstudio.com/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

** using staged installation

Oracle Client Shared Library 64-bit - 19.3.0.0.0 Operating in Instant Client mode.

found Instant Client C:\Oracle\instantclient\instantclient_19_3

found Instant Client SDK C:\Oracle\instantclient\instantclient_19_3/sdk/include

copying from C:\Oracle\instantclient\instantclient_19_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:/Users/kenliu/DOCUME~1/R/R-36~1.1/include" -DNDEBUG -I./oci         -O2 -Wall  -std=gnu99 -mtune=generic -c rodbi.c -o rodbi.o

sh: C:/Rtools/mingw_64/bin/gcc: Is a directory

make: *** [C:/Users/kenliu/DOCUME~1/R/R-36~1.1/etc/x64/Makeconf:208: rodbi.o] Error 126

ERROR: compilation failed for package 'ROracle'

* removing 'C:/Users/kenliu/Documents/R/win-library/3.6/ROracle'

Warning in install.packages :

  installation of package ‘ROracle’ had non-zero exit status

The downloaded source packages are in

‘C:\Users\kenliu\AppData\Local\Temp\RtmpuETwyG\downloaded_packages’

Sherry Lamonica-Oracle

Hi Ken,

Please try the ROracle 1.3-2 Windows binary for R-3.6.x here:

https://www.oracle.com/database/technologies/roracle-downloads.html

Pleas post again if you experience any issues installing the Windows binary.

Sherry