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

client is spelled wrong in the text

Worked great. Lifesaver. System: Debian 8

Brilliant, this is always a pain. Thanks 👍

He missed later add the line.
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib

Lifesaver for me 👍

https://help.ubuntu.com/community/Oracle%20Instant%20Client

can't find oracle-instantclinet*-devel-*.rpm here http://www.oracle.com/technetwork/topics/linux-power-le-2835260.html

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 // hector_cervantes@msn.com<mailto:hector_cervantes@msn.com> P // 314.629-5537<tel:314.629-5537> On Oct 11 2019, at 3:07 pm, sssshah <notifications@github.com> 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.