Cfxtrjtrk

I tried installing sqlplus by following the instruction from here. I'm still getting :

sqlplus: command not found

when I do sqlplus from my terminal.

I'm an novice in Ubuntu and I use Ubuntu 12.04.

First of all you need to download Instant Client Downloads. Install alien package so you can install rpm packages by typing following command in terminal.

sudo apt-get install alien

Once that is done, go to the folder where the rpm files are located and execute the following:

sudo alien -i oracle-instantclient*-basic*.rpm

sudo alien -i oracle-instantclient*-sqlplus*.rpm

sudo alien -i oracle-instantclient*-devel*.rpm

You need to install libaio.so. Type following command to do it:

sudo apt-get install libaio1

Create Oracle configuration file:

sudo sensible-editor /etc/ld.so.conf.d/oracle.conf

Put this line in that file:

/usr/lib/oracle/<your version>/client/lib/ 

Note - for 64-bit installations, the path will be:

/usr/lib/oracle/<your version>/client64/lib/ 

Update the configuration by running following command:

sudo ldconfig

Try to connect using:

sqlplus username/password@//dbhost:1521/SID

or:

sqlplus testuser/password

Note that if you installed the 64-bit version, the client is called sqlplus64.

The alien thing didn't work because of:

Error: cannot open Name index using db5 - Permission denied (13)

So I went with the easy solution: Download the zip files from Oracle (basic and sqlplus), extract them, and put the folder where you put program files (e.g. /usr/share). Then create a script that runs the executable after setting the LD_LIBRARY_PATH variable, so that libraries are found:

#!/bin/bash

DIR=/usr/share/instantclient_12_2 # <------- adjust this to the path you use

export LD_LIBRARY_PATH="$DIR"

"$DIR"/sqlplus "$@"

Call it sqlplus, make it executable (chmod 755 sqlplus) and put it into a directory on your PATH (e.g. /usr/bin/), so that bash finds it.

Run it like

sqlplus user/password@host:port/service

If you get

error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

install the library with sudo apt-get install libaio1

I think this link would help. It is pretty descriptive. Make sure you follow all the steps. Still if you have any problems, don't hesitate to comment.

Of course the correct installation is from official packages like above (download Instant Client Downloads), but you can get a full working sqlplus just by copying these files (you can found it in any computer with oracle client installed), and some msb are optitional:

./sqlplus

./sqlplus/mesg

./sqlplus/mesg/sp1zhs.msb

./sqlplus/mesg/sp2zhs.msb

./sqlplus/mesg/sp2ptb.msb

./sqlplus/mesg/sp2us.msb

./sqlplus/mesg/sp1us.msb

./sqlplus/mesg/sp1ptb.msb

./sqlplus/mesg/cpyja.msb

./sqlplus/mesg/sp1ja.msb

./sqlplus/mesg/cpyus.msb

./sqlplus/mesg/cpyzhs.msb

./sqlplus/mesg/cpyptb.msb

./sqlplus/mesg/sp2ja.msb

./sqlplus/sqlplus

./README

./lib

./lib/libaio.so.1

./lib/libclntsh.so.11.1

./lib/libsqlplus.so

./lib/libnnz11.so

./lib/libociei.so

As aditional dependency, I did include libaio.so - it can be installed with sudo apt-get install libaio1

So, a sample use can be:

cd <PATH_OF_FILES>

ORACLE_HOME=$PWD LD_LIBRARY_PATH=$PWD/lib ./sqlplus/sqlplus user/pw@server:PORT/