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

The real MVP

This is great! Thank you! Btw, if you're using Oracle 18c, than you may need to change it to /usr/lib/oracle/18.3/client64/lib/
Also, you can find the default /network/admin directory here - /usr/lib/oracle/18.3/client64/lib/network/admin
This is the location for sqlnet.ora, tnsnames.ora etc

Thanks, you help me!!

I'm getting: sqlplus: command not found
I've install 19.3 basic lite and it seems to not recognize sqlplus command. I've set ORACLE_HOME to the correct value. If I navigate to /usr/lib/oracle/19.3/client64, I do not see sqlplus command anywhere there.

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

Thank you. I will give it a try. Hector Cervantes [https://user-generated.getmailspring.com/asset/ZDE3ZmMxYmQtMGQ1My00Mzg3LWFkZDYtZDA2ODc2ZDE4NDAxL3NpZy1sb2NhbC00YWNhYTI2Yi00OTkzLnBuZw.png?t=1571149746408&msw=200&msh=200] E // [email protected]<mailto:[email protected]> P // 314.629-5537<tel:314.629-5537> On Oct 11 2019, at 3:07 pm, sssshah <[email protected]> wrote: Make sure you have installed oracle-instantclinet*-sqlplus-*.rpm as well. The basic client does not have SqlPlus. — You are receiving this because you commented. Reply to this email directly, view it on GitHub<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgist.github.com%2F7316877%3Femail_source%3Dnotifications%26email_token%3DAA4M5QH7TOVZ2EGDC5EPJSLQODFHPA5CNFSM4H7QPTLKYY3PNVWWK3TUL52HS4DFVNDWS43UINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAF2KXY%23gistcomment-3052924&data=02%7C01%7C%7C5050b692f8984942863808d74e7e4744%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637064176568912456&sdata=owJ9JkezpLVZeS5o4ROZRMV7M5CmCQMRDDw2VPVVs%2F8%3D&reserved=0>, or unsubscribe<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAA4M5QDFA7EIKRIRV7GDLW3QODFHPANCNFSM4H7QPTLA&data=02%7C01%7C%7C5050b692f8984942863808d74e7e4744%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637064176568922467&sdata=Ww9VmdJm9477fl%2Bbe5DSQ06RXMF8KLejQybRvb8wKKk%3D&reserved=0>.

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.