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/ whereas 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 both installed on your server, you can create a symbolic link with the following command:
ln -s /usr/lib/oracle/19.12/client64/lib/* /opt/rstudio-drivers/oracle/bin/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
Note: Whenever you modify
rserver.conf, make sure to restart the RStudio Server Pro service.