sqlplus: No such file or directory

Hello,
I installed on my ubuntu 8.04.4 the oracle instant client 10.2.0.4.0 and that installation worked correctly as I can connect the oracle instances. Now I'm trying to get sqlplus to work but haven't been successful.

Here is the error I get:

# sqlplus
-bash: /opt/oracle/instantclient_10_2/sqlplus: No such file or directory

Here the relevant environment variables:

#env | sort
DYLD_LIBRARY_PATH=/opt/oracle/instantclient_10_2
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/opt/oracle/instantclient_10_2
OLDPWD=/opt/oracle
ORACLE_HOME=/opt/oracle/instantclient_10_2
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/oracle/instantclient_10_2
PWD=/opt/oracle/instantclient_10_2
SQLPATH=/opt/oracle/instantclient_10_2
USER=root

Here the files in the instantclient_10_2 directory

# ls -l
total 35984
-rw-rw-r-- 1 root root      238 2008-03-12 08:37 BASIC_LITE_README
-r--r--r-- 1 root root  1609607 2008-03-12 08:37 classes12.jar
-rwxrwxr-x 1 root root    67542 2008-03-12 08:37 genezi
-rwxr-xr-x 1 root root     1525 2012-08-23 16:37 glogin.sql
lrwxrwxrwx 1 root root       17 2009-11-27 10:01 libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-x 1 root root 21038613 2008-03-12 08:37 libclntsh.so.10.1
-r-xr-xr-x 1 root root  3796601 2008-03-12 08:37 libnnz10.so
lrwxrwxrwx 1 root root       15 2009-11-27 10:01 libocci.so -> libocci.so.10.1
-rwxrwxr-x 1 root root  1664116 2008-03-12 08:37 libocci.so.10.1
-rwxrwxr-x 1 root root  4351321 2008-03-12 08:37 libociicus.so
-r-xr-xr-x 1 root root   138033 2008-03-12 08:37 libocijdbc10.so
-rwxr-xr-x 1 root root  1434263 2012-08-23 16:37 libsqlplusic.so
-rwxr-xr-x 1 root root  1069221 2012-08-23 16:37 libsqlplus.so
-r--r--r-- 1 root root  1555682 2008-03-12 08:37 ojdbc14.jar
drwxrwxr-x 4 root root     4096 2008-03-12 08:37 sdk
-rwxr-xr-x 1 root root     8903 2012-08-23 16:37 sqlplus
-rw-r--r-- 1 root root      242 2012-08-23 16:37 SQLPLUS_README

Would you able to help me to find the problem?

Thanks
DV

It's a separate download from Oracle. You need to download the one which matches your Operating System.

1 Like

Great! It works! Thanks!

1 Like

i have exactly the same error. Can you tell me please what was the solution Which package i have to download? I don't understand "sqlplus: No such file or directory"? Thanks a lot

---------- Post updated at 06:21 AM ---------- Previous update was at 06:20 AM ----------

a error just above i don't understand the phrase You need to download the one which matches your Operating System.

What is the name of the UNIX OS you use? Solaris? Debian? Suse? So you choose the download meant to work on your machine.

linux i686 (32 bits)

---------- Post updated at 07:43 AM ---------- Previous update was at 07:39 AM ----------

maybe because i have installed instantclient-sqlplus-linux.x64-11.2.0.3.0.zip and instantclient-basic-linux.x64-11.2.0.3.0.zip instead of 32bits . I will try

---------- Post updated at 09:48 AM ---------- Previous update was at 07:43 AM ----------

no it doesn't still work