Hey @albert ! Welcome to RStudio Community!!
It's worth noting a couple of things:
- The "OCI libraries" are an Oracle thing. As far as I understand, no connection to Oracle can succeed without these libraries (1) installed on the system and (2) configured properly with whatever library you are using
- ROracle is woefully un-maintained - last updated in 2016
- We have seen several of our customers be more successful (though it can still be tricky to configure the OCI libraries properly) with the
odbc package and an ODBC connection to Oracle: https://github.com/r-dbi/odbc
In particular, since you are using RStudio Connect, RStudio provides professional drivers which include an Oracle driver and should help you get set up connecting to your oracle database!
A specific guide on installation is here:
https://docs.rstudio.com/pro-drivers/installation/
Once you have the drivers installed, you should be able to configure an odbc connection (and even get it working outside of R with a DSN, isql, or otherwise). Then it should be easy to make use of within R! There are lots of ways to make this possible, many of which are discussed here:
https://db.rstudio.com/best-practices/portable-code/