5

I would like to install Oracle Instant Client on a Ubuntu 64 bit machine.

Following this link, I have installed the rpm packages basic, development and sqlplus using alien.

Then:

sqlplus  username/password@//dbhost:1521/SID
sqlplus: command not found

export ORACLE_HOME=/usr/lib/oracle/12.1/client64
ls $ORACLE_HOME
bin  lib

sqlplus
sqlplus: command not found

I have tried the python script in this link, but this did not work. It conflicts with the installed 12.1 packages as it tries to install 11.2.

1 Answer 1

9

Easily solved:

export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Stick those lines in your ~/.bash_profile if you want them to persist for a given user, or in /etc/bashrc to persist for all users.

4
  • Thanks Phil - it worked. Stuck it into ~/.bashrc. [/etc contained only bash.bashrc].
    – Henk
    Commented Jun 4, 2014 at 13:14
  • +1 for helping users to use oracle db even on distributions which are considered "unsupported" by the company.
    – peterh
    Commented Jun 12, 2014 at 13:27
  • @Peter -1 for appearing to have an attitude problem towards me
    – Philᵀᴹ
    Commented Jun 12, 2014 at 13:30
  • @Phil Is it possible for me to contact you privately?
    – peterh
    Commented Jun 12, 2014 at 16:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.