Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

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.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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