I'm having trouble installing the ROracle package for R 4.0.3 on Windows 10:
> install.packages("ROracle")
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
ERROR: C:\oracle\product\12.1.0\client_1\BIN; directory does not exist.
ERROR: configuration failed for package 'ROracle'
* removing 'C:/Program Files/R/R-4.0.3/library/ROracle'
* restoring previous 'C:/Program Files/R/R-4.0.3/library/ROracle'
Warning in install.packages :
installation of package ‘ROracle’ had non-zero exit status
The downloaded source packages are in
‘C:\...\AppData\Local\Temp\Rtmpe44NyI\downloaded_packages’
I've set C:\oracle\product\12.1.0\client_1\BIN as OCI_LIB64 and PATH environment variables, and C:\oracle\product\12.1.0\client_1\oci\include as the OCI_INC environment variable. I've also verified that Rtools is downloaded and working properly. These directories seem accessible to R (i.e. using dir.exists() with these paths returns TRUE). Can anyone help me understand why I'm getting an error message that says the OCI_LIB64 directory doesn't exist when it clearly does..?
FWIW, I've also tried running RStudio as admin with no luck. Any help would be greatly appreciated!