ROracle on Linux

1.
sudo apt-get install alien
sudo apt-get install libaio1
2.
Download:
 
oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-devel-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-sqlplus-12.2.0.1.0-1.x86_64.rpm

(http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)
3.
sudo alien -i oracle-instantclient12.1-basic-12.2.0.1.0-1.x86_64.rpm
sudo alien -i oracle-instantclient12.1-devel-12.2.0.1.0-1.x86_64.rpm
sudo alien -i oracle-instantclient12.1-sqlplus-12.2.0.1.0-1.x86_64.rpm

4.
export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH}
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export PATH=$PATH:$ORACLE_HOME/bin

echo "/usr/lib/oracle/12.2/client64/lib" | sudo tee /etc/ld.so.conf.d/oracle.conf
sudo ldconfig -v

5.
echo $LD_LIBRARY_PATH
echo $ORACLE_HOME
echo $PATH
sqlplus   # should give you the command prompt

sudo chmod 755  /usr/local/lib/R/site-library/

6.
sudo R CMD INSTALL --configure-args='--with-oci-lib=/usr/lib/oracle/18.3/client64/lib --with-oci-inc=/usr/include/oracle/18.3/client64' /home/xuefliang/Downloads/ROracle_1.3-1.tar.gz