SQL*Plus

alias

alias sp='rlwrap sqlplus64 username/password@//dbhost:1521/SID'

alien.sh

sudo apt-get install alien

error

sqlplus64: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

install.sh

sudo alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
sudo alien -i oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
sudo alien -i oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm

install_rlwrap.sh

sudo apt-get install rlwrap

ld.so.conf.d.sh

sudo nano /etc/ld.so.conf.d/oracle.conf

libaio.1.sh

sudo apt-get install libaio1

path

/usr/lib/oracle/12.1/client64/lib/

rlwrap.sh

rlwrap sqlplus64 username/password@//dbhost:1521/SID

sp.sh

sp

test.sh

sqlplus64 username/password@//dbhost:1521/SID