Skip to content

Instantly share code, notes, and snippets.

@tcnksm

tcnksm/install_sqlplus.md

Last active February 4, 2022 12:43
Show Gist options
  • Save tcnksm/7316877 to your computer and use it in GitHub Desktop.
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

  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
@nmofonseca
Copy link

nmofonseca commented Oct 7, 2020 •
edited

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
Copy link

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.

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