Instructions on how to install ROracle for R on Windows.

install ROracle on Windows.md

Download binary from oracle: http://www.oracle.com/technetwork/database/database-technologies/r/roracle/downloads/index.html

The run the following command in r, substituting the file path:

setwd('xxxxx')   # set to path of download
install.packages('ROracle_1.1-11.zip', repos = NULL)

Then load the library and use the package - you may have to change XXXX to whatever is in your TNS Names:

library('ROracle')
drv <- dbDriver("Oracle")
# NOTE: never store passwords in a saved script!!
con <- dbConnect(drv, "USER GOES HERE", "PASSWORD GOES HERE", dbname='XXX')

test connection:

dbReadTable(con, 'DUAL')

after installing the package, get this error:

library('ROracle')
Loading required package: DBI
Error in inDL(x, as.logical(local), as.logical(now), ...) :
unable to load shared object 'C:/Users/xxxx/Documents/R/win-library/3.3/ROracle/libs/x64/ROracle.dll':
LoadLibrary failure: %1 is not a valid Win32 application.

Error: package or namespace load failed for ‘ROracle’

@huaminji The package only includes the 64bits version of the library, in order to use it you must load it from a 64-bits version of R, or you could build the 32bit version yourself: https://cran.r-project.org/web/packages/ROracle/INSTALL

After installing I get the following error:

Loading required package: DBI
Error in inDL(x, as.logical(local), as.logical(now), ...) : 
unable to load shared object 'C:/Users/alex.cauthen/Documents/R/win-library/3.3/ROracle/libs/x64/ROracle.dll':
LoadLibrary failure:  The specified module could not be found.
Error: package or namespace load failed for ‘ROracle’

As well as the following windows error:
The program can't start because of OCI.dll is missing from your computer. Try reinstalling the program to fix this problem.

I tried loading the DBI package before calling library('ROracle') which only removes the first line of the error. I have downloaded the R-3.3.2 for windows 32/64 bit install. Is that correct?

EDIT: After running the Sys.getenv command I have determined that I am running the 64 bit version of R.

I'm also getting the same error after installing and trying to load ROracle.

Loading required package: DBI
Error in inDL(x, as.logical(local), as.logical(now), ...) :
unable to load shared object 'C:/Program Files/R/R-3.2.3/library/ROracle/libs/x64/ROracle.dll':
LoadLibrary failure: The specified module could not be found.

Error: package or namespace load failed for ‘ROracle’

However, before I get that error message, I get this dialog box error pop up:
"The program can't start because OCI.dll is missing from your computer. Try reinstalling the program to fix this problem."

Any ideas how to fix the OCI.dll? Where would I download this and put into?

I am getting exactly the same message. Any update on what is causing this problem. I have SQL Developer installed and it is working. OCI_INC set to C:\Oracle\Product\11.2.0\client_1\oci\include , I tried setting OCI_LIB64 too, but didn't work.

Installing Oracle Client on my computer fixed this issue.

For anyone else having trouble installing ROracle, the installation instructions on CRAN are actually very good and the links appear to all be working at the time of posting this. http://cran.us.r-project.org/web/packages/ROracle/INSTALL

True, the CRAN instructions and error resolution page is quite extensive. Thanks for the link. However, I am experiencing the same issue and the error message I get does not match precisely any of those on the page.

"Error: package or namespace load failed for ‘ROracle’ in inDL(x, as.logical(local), as.logical(now), ...):
unable to load shared object '//SomeUniversity/HOME/R/win-library/3.4/ROracle/libs/x64/ROracle.dll':
LoadLibrary failure: The specified module could not be found."

The file is in the directory, compiled in x64 and running x64; Anyone know if the function 'inDL' is part of ROracle? DBI?

Your instructions are very clear and easy to follow. Thanks

Installing Oracle Client on my computer fixed this issue.

@gmonteeiro just that you had to install it or did you need some extra configuration? Because it still does not work :(

ROracle is not working with new version 3.5.0. Do you know why ?

@siddhesh1991 ROracle is not working for as well on the new R 3.5.0. Did you find any solutions?

Same here. I've just installed R 3.5.0 - and i get an error when loading the package:

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

Has anyone found a solution to this?

library('ROracle')
Loading required package: DBI 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

R version 3.5.0 (2018-04-23) -- "Joy in Playing"

ROracle is not working with the new version of R, Can anyone help ?

We looked everywhere for a solution, to no avail...had to roll back to 3.4. Thanks Larry E 👎

Hello,

I had similar error. Here are few things that I have done to make it work successfully on windows X-64 machine.

0. Downloaded Oracle instant client and unzipped it (copy its path). Then added a new variable in the existing Path variable (under System Variables), paste this path here.
1. Uninstalled all R versions.
2. Reinstalled R (Version R-3.5.1)
3. Downloaded ROracle package (ROracle_1.3-1.zip) from https://www.oracle.com/technetwork/database/database-technologies/r/roracle/downloads/index.html . Save the downloaded zip file
4. Open RStudio (or whatever you use) and run the below:

install.packages("C:\\Users\\username\\Desktop\\Software\\R\\ROracle_1.3-1.zip")   
library("ROracle")

Then ROracle got installed correctly. Make sure you are installing the downloaded package from step-3

Let me know if it still doesn't work. Happy to help!

Hi @jssasan, when following your steps I get the following error:

Warning in install.packages : package ‘C:\Users\codrin_kruijne\Documents\ROracle\ROracle_1.3-1.zip’ is not available (for R version 3.5.1)

so I set the repos to NULL:

install.packages("C:\\Users\\codrin_kruijne\\Documents\\ROracle\\ROracle_1.3-1.zip", repos = NULL) 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

but when I try to load it I get the following error:

library(ROracle) Loading required package: DBI 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

so I downloaded RTools to recompile it from the source on CRAN:

install.packages("ROracle")
Installing package into ‘C:/Users/codrin_kruijne/Documents/R/win-library/3.5’
(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
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\instantclient_18_3
found Oracle Client include C:\Users\codrin_kruijne\Documents\ROracle\instantclient_18_3\sdk\include
copying from C:\Users\codrin_kruijne\Documents\ROracle\instantclient_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 ‘ROracle’ had non-zero exit status

The downloaded source packages are in
	‘C:\Users\codrin_kruijne\AppData\Local\Temp\Rtmpi0YaXx\downloaded_packages’

Can you help? Thanks!

Installation of ROracle is a bit tricky.

1. Download ROracle package on your PC: https://www.oracle.com/database/technologies/roracle-downloads.html
   Download the tar.gz package!

2. Access the INSTALL file on ROracle sub-directory and follow the instructions. The installation differs if you have or not Oracle installed on your machine.

Good instructions in: # https://medium.com/analytics-vidhya/how-to-install-roracle-on-windows-10-144b0b923dac

IMPORTANT

ROracle can't be directly installed on R4+

So, download ROracle package on your PC: https://www.oracle.com/database/technologies/roracle-downloads.html
Download the tar.gz package!

Install it on your RStudio with the following command:

install.packages('C:\Downloads\ROracle_1.3-2.tar.gz', repos = NULL, type="source")

Don't forget to correct the directory in which you've downloaded the file. This will recompile your package to version 4 of R.