I am attempting to install the ROracle package in RStudio so that I may connect R to my Oracle databases. I downloaded the zip file but when I run
remotes::install_local("ROracle_1.3-2.tar.gz", repos = NULL, type = "source")
I get an error :
ERROR: cannot find Oracle Client. Please set OCI_LIB64 to specify its location.
I do have Oracle Client installed on my PC. This may be an obvious answer, but my question is, how do I set OCI_LIB64 to recognize Oracle CLient's location on my PC. I am running on windows 10 and R version 4.1.3.
Have a look at the installation guide. It has the following steps for windows:
13.Add the full path of the Instant Client to the environment variables
OCI_LIB64 and PATH.
The following steps set the variables to the PATH used in this example,
c:\myoreclient\instantclient_11_2.
1. In Windows Control Panel, select System, then click Advanced system
settings.
2. On the Advanced tab, click Environment Variables.
3. Under System variables, create OCI_LIB64 if it does not already exist.
4. Set the value of OCI_LIB64 to c:\oreclient\instantclient_11_2.
5. Under System variables, edit PATH to include
c:\oreclient\instantclient_11_2.