first binary publish.
to use from R:
setwd("DownloadedDirectory")
install.packages("RJDBC.tar.gz")
library(RJDBC)
drv <- JDBC("oracle.jdbc.driver.OracleDriver", "/opt/oracle/instantclient_19_3/ojdbc8.jar")
conn <- dbConnect(drv, "jdbc:oracle:thin:@YOURDATABASE_tp", "admin", "YOURPASSWORD")
dn <- dbReadTable(conn,"yourtable")