Connecting to Oracle databases with Posit 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 Posit Professional Drivers typically install under /opt/rstudio-drivers/. See Getting Started with Posit 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 Posit Workbench is to add a line to rserver.conf:
rsession-ld-library-path=/usr/lib/oracle/19.12/client64/libNote: Whenever you modify rserver.conf, make sure to restart the Posit Workbench service.
Comments