Support

Connecting to Oracle databases with RStudio Professional Drivers

Follow

Connecting to Oracle databases with RStudio Professional Drivers requires the Oracle Instant Client. Check the Oracle ODBC Driver Installation and Configuration Guide to verify which version of the Oracle Instant Client is required.

The Oracle Instant Client typically installs under /usr/lib/oracle/ wherease the RStudio Professional Drivers typically install under /opt/rstudio-drivers/. See Getting Started with RStudio Professional Drivers for instructions on how to install the pro drivers.

After the pro drivers and the Instant Client are installed on your server, you can create a symbolic link with the following command:

ln -s /usr/lib/oracle/12.1/client64/lib/* /opt/rstudio-drivers/oracle/lib/

If you prefer to use an environment variable instead of a symbolic link, you can point your LD_LIBRARY_PATH at the installation path for the Oracle Instant Client. An easy way to do this with RStudio Server Pro is to add a line to rserver.conf:

rsession-ld-library-path=/usr/lib/oracle/12.1/client64/lib

Note: Whenever you modify rserver.conf, make sure to restart the RStudio Server Pro service.

Comments