tcnksm/install_sqlplus.md

Last active February 4, 2022 12:43

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tcnksm/7316877.js"></script>
Save tcnksm/7316877 to your computer and use it in GitHub Desktop.

Download ZIP

How to install oracle client to Ubuntu 12.04

Raw

install_sqlplus.md

Install SQL*Plus

Download .rpm package here
- oracle-instantclinet*-basic-*.rpm
- oracle-instantclinet*-devel-*.rpm
- oracle-instantclinet*-sqlplus-*.rpm
Install alien (sudo apt-get install alien)
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
Install libaio1
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

hcervantes commented Oct 15, 2019 via email

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>.

hcervantes commented Oct 15, 2019 •

edited

Loading

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}

YoshiTheChinchilla commented Oct 18, 2019

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

janakact commented Jan 27, 2020

Works great. Thanks ^_^

Daniel-Lima-Carvalho commented Aug 31, 2020

It worked. Thank you.

nmofonseca commented Oct 7, 2020 •

edited

Loading

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.

Ryanb58 commented Sep 21, 2021

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.