Skip to content

Instantly share code, notes, and snippets.

@tcnksm
Last active February 4, 2022 12:43
Show Gist options
  • Select an option

  • Save tcnksm/7316877 to your computer and use it in GitHub Desktop.

Select an option

Save tcnksm/7316877 to your computer and use it in GitHub Desktop.
How to install oracle client to Ubuntu 12.04

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
@Prithvirajbilla

Copy link
Copy Markdown

client is spelled wrong in the text

@m3nu

m3nu commented Mar 30, 2016

Copy link
Copy Markdown

Worked great. Lifesaver. System: Debian 8

@epidemicz

Copy link
Copy Markdown

Brilliant, this is always a pain. Thanks 👍

@Hayllander

Copy link
Copy Markdown

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

@simonmilz

Copy link
Copy Markdown

Lifesaver for me 👍

@mloskot

mloskot commented Sep 24, 2017

Copy link
Copy Markdown

@raghav18gupta

Copy link
Copy Markdown

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

@ricardoaat

Copy link
Copy Markdown

The real MVP

@sssshah

sssshah commented Jul 10, 2019

Copy link
Copy Markdown

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

@VinnyLima

Copy link
Copy Markdown

Thanks, you help me!!

@hcervantes

Copy link
Copy Markdown

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.

@sssshah

sssshah commented Oct 11, 2019

Copy link
Copy Markdown

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

@hcervantes

hcervantes commented Oct 15, 2019 via email

Copy link
Copy Markdown

@hcervantes

hcervantes commented Oct 15, 2019

Copy link
Copy Markdown

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

Copy link
Copy Markdown

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

@janakact

Copy link
Copy Markdown

Works great. Thanks ^_^

@Daniel-Lima-Carvalho

Copy link
Copy Markdown

It worked. Thank you.

@nmofonseca

nmofonseca commented Oct 7, 2020

Copy link
Copy Markdown

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

Ryanb58 commented Sep 21, 2021

Copy link
Copy Markdown

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment