How to install oracle client to Ubuntu 12.04

install_sqlplus.md

Install SQL*Plus

1. Download .rpm package here
   • oracle-instantclinet*-basic-*.rpm
   • oracle-instantclinet*-devel-*.rpm
   • oracle-instantclinet*-sqlplus-*.rpm
2. Install alien (sudo apt-get install alien)
3. Convert the rpm files and install
   • sudo alien -i oracle-instantclinet*-basic-*.rpm
   • sudo alien -i oracle-instantclinet*-devel-*.rpm
   • sudo alien -i oracle-instantclinet*-sqlplus-*.rpm
4. Install libaio1
5. Add oracle.conf (echo /usr/lib/oracle/12.1/client/lib > /etc/ld.so.conf.d/oracle.conf) and Reload .conf (sudo ldconfig)
   • • If libsqlplus.so: cannot open shared object file: No such file or directory is displayed when execute sqlplus

Make sure you have installed oracle-instantclinet*-sqlplus-*.rpm as well. The basic client does not have SqlPlus.

This worked. After I installed the oracle-instantclient19.3-sqlplus-19.3.0.0.0-1.x86_64.rpm, I had to integrate the Ora libs by:
export LD_LIBRARY_PATH=/usr/lib/oracle/19.3/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH}

It's not "oracle-instantclinet*"!
The right name is "oracle-instantclient*"

Works great. Thanks ^_^

It worked. Thank you.

Thansk for this.
The installation was preety smoth using 12.2 instead of 12.1 like in ubuntu server. For some reason when I tried in WSL2 Ubuntu the installation also works however even with export TNS_ADMIN=pathtotnsnames or placing tnsnames.ora/sqlnet.ora into /usr/lib/oracle/12.2/client64/lib/network/admin or /usr/lib/oracle/12.2/client64/network/admin it still doesn't connect to the databases. As anyone tried this in WSL2? Cheers.

Sadly, the Instant Client does not have what I am looking for... tnsping. I think you have to install the full client to get that specific tool.