Install ROracle

roracle.sh

https://thraxys.wordpress.com/2016/10/25/install-roracle-on-linux/
  
  # Downloads -------------------------------------------------------------

wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-jdbc-19.8.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-odbc-19.8.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/19800/oracle-instantclient19.8-sqlplus-19.8.0.0.0-1.x86_64.rpm

# Installs ---------------------------------------------------------------
sudo alien -i oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm
sudo alien -i oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm
sudo alien -i oracle-instantclient19.8-jdbc-19.8.0.0.0-1.x86_64.rpm
sudo alien -i oracle-instantclient19.8-odbc-19.8.0.0.0-1.x86_64.rpm
sudo alien -i oracle-instantclient19.8-sqlplus-19.8.0.0.0-1.x86_64.rpm
# 
export LD_LIBRARY_PATH=/usr/lib/oracle/19.8/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH}
export ORACLE_HOME=/usr/lib/oracle/19.8/client64
export PATH=$PATH:$ORACLE_HOME/bin
# 
echo "/usr/lib/oracle/19.8/client64/lib" | sudo tee /etc/ld.so.conf.d/oracle.conf
sudo ldconfig -v

# 
echo $LD_LIBRARY_PATH
echo $ORACLE_HOME
echo $PATH
sqlplus   # should give you the command prompt
# 
# https://cran.r-project.org/web/packages/ROracle/index.html
wget https://cran.r-project.org/src/contrib/ROracle_1.3-1.tar.gz
sudo R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/19.8/client64/lib --with-oci-inc=/usr/include/oracle/19.8/client64' ROracle_1.3-1.tar.gz