Skip to content

Instantly share code, notes, and snippets.

@bmaupin
Last active February 2, 2024 04:38
Show Gist options
  • Save bmaupin/1d376476a2b6548889b4dd95663ede58 to your computer and use it in GitHub Desktop.
Save bmaupin/1d376476a2b6548889b4dd95663ede58 to your computer and use it in GitHub Desktop.
Install Oracle client on Ubuntu

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

Tested on: Ubuntu 18.04, 20.04

  1. Decide which version of the Oracle client to install

  2. Download the Oracle client packages

  3. Install prerequisites

    sudo apt install alien libaio1
    
  4. Install the Oracle client package(s)

    sudo alien -i oracle-instantclient19.12-basiclite-19.12.0.0.0-1.x86_64.rpm
    
  5. Update the system library path to include the oracle libraries

    Note: This doesn't seem to be necessary any more; maybe it's included in the newer versions of the Oracle library package now?

    sudo sh -c 'echo /usr/lib/oracle/19.12/client64/lib/ > /etc/ld.so.conf.d/oracle.conf'
    sudo ldconfig
    
@PaleNeutron
Copy link

if someone use version 21.6 the last step should be

sudo sh -c  'echo /usr/lib/oracle/21/client64/lib/ > /etc/ld.so.conf.d/oracle.conf'

@kfous
Copy link

kfous commented Feb 23, 2023

Well done, worked for me. If anyone is just trying to update Library Path with the newly installed instant client location, it won't work.

Following step 5. will do the job.

@LaoZhangRen
Copy link

如果有人使用版本 21.6,最后一步应该是

sudo sh -c  'echo /usr/lib/oracle/21/client64/lib/ > /etc/ld.so.conf.d/oracle.conf'

nice

@dinesh-patil59
Copy link

Hello,
I am not able to find the tnsnames.ora file can you help me out, I am using ubuntu 20.04.

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