Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sqlplus: No such file or directory
Operating Systems Linux Ubuntu sqlplus: No such file or directory Post 302690739 by daniloviz on Thursday 23rd of August 2012 10:17:13 AM
Old 08-23-2012
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:
Code:
# sqlplus
-bash: /opt/oracle/instantclient_10_2/sqlplus: No such file or directory

Here the relevant environment variables:
Code:
#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
Code:
# 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
 

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Hi, I want to input unix variable to sqlplus.The following is working fine sqlplus username/password @dummy.sql param1 param2 << EOF create user $1 identified by $2; EOF But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that?? Thanks... (3 Replies)
Discussion started by: sakthi.abdullah
3 Replies

2. UNIX for Dummies Questions & Answers

File Format issue: Output of sqlplus

Hi, I am using a query like below in my shell script : { { echo "set echo off" echo "set head off" echo "whenever sqlerror exit -1; select NUMBER ||','|| FNAME ||','|| LOC ||','|| ... (2 Replies)
Discussion started by: deepakgang
2 Replies

3. UNIX for Dummies Questions & Answers

SQLPlus spool file

HI Have some problem with spooling out some relatively large number of records (~2-3 mil) Small table - OK though. Getting error: SP2 0308: cannot close spool file. Any thoughts? sqlplus -s user/pwd << EOF set term off set head off set trims on set pages 0 set... (1 Reply)
Discussion started by: Leo_NN
1 Replies

4. Shell Programming and Scripting

error running sqlplus from shell file

I am running a shell file following script on bash shell in solaris 10 ( echo abc@orcl echo abc echo "set feedback off" echo "truncate table SIndexDataTypeHst1_changes;" ) | sqlplus -s but getting the following error ERROR: ORA-01005: null password given; logon denied ... (3 Replies)
Discussion started by: mmunir
3 Replies

5. UNIX for Dummies Questions & Answers

SQLPLUS Password Parameter file being used when logging in

Good day to everyone. This is my first time posting and just barely above basic Unix training. I think i have search thoroughly to ensure my question hasn't already been posted. But on the off chance the answer has been posted, please be nice as I am not 100% sure I know what I am looking for. I... (1 Reply)
Discussion started by: Mrjester
1 Replies

6. Shell Programming and Scripting

How to get sqlplus column header once in csv file?

Hi All, Could anyoone please let me know how do I get sqlplus column header once in csv file Scripts are below: cat concreq.sh #!/bin/bash . $HOME/.profile while ; do sqlplus apps/pwd <<-EOF set lines 100 pages 100 col "USER_CONCURRENT_QUEUE_NAME" format a40; --set termout off... (5 Replies)
Discussion started by: a1_win
5 Replies

7. Shell Programming and Scripting

Generating file from sqlplus

Hi Frndz, I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file. PFB the code i have written: #----Start job log--- SQLLOG='/opt/app/vertica2/cdr_dev/logs/conn_orac_db.log' ORA_USER='abc' ORA_PASSWD='xyz' ... (7 Replies)
Discussion started by: gnnsprapa
7 Replies

8. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies

9. Programming

How to pass parameter from file to sqlplus in UNIX?

i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different. 343535435 365765767 343534543 343543543 i want to pass this file to sqlplus and sql command is ... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies

LEARN ABOUT POSIX

gzexe

GZEXE(1)						      General Commands Manual							  GZEXE(1)

NAME

       gzexe - compress executable files in place

SYNOPSIS

       gzexe name ...

DESCRIPTION

       The  gzexe  utility  allows you to compress executables in place and have them automatically uncompress and execute when you run them (at a
       penalty in performance).  For example if you execute ``gzexe /usr/bin/gdb'' it will create the following two files:
	   -rwxr-xr-x  1 root root 1026675 Jun	7 13:53 /usr/bin/gdb
	   -rwxr-xr-x  1 root root 2304524 May 30 13:02 /usr/bin/gdb~
       /usr/bin/gdb~ is the original file and /usr/bin/gdb is the self-uncompressing executable file.  You can remove /usr/bin/gdb~ once  you  are
       sure that /usr/bin/gdb works properly.

       This utility is most useful on systems with very small disks.

OPTIONS

       -d     Decompress the given executables instead of compressing them.

SEE ALSO

       gzip(1), znew(1), zmore(1), zcmp(1), zforce(1)

CAVEATS

       The  compressed executable is a shell script.  This may create some security holes.  In particular, the compressed executable relies on the
       PATH environment variable to find gzip and some standard utilities (basename, chmod, ln, mkdir, mktemp, rm, sleep, and tail).

BUGS

       gzexe attempts to retain the original file attributes on the compressed executable, but you may have to fix them manually  in  some  cases,
       using chmod or chown.

																	  GZEXE(1)
All times are GMT -4. The time now is 01:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy