Home » Other » Client Tools » sqlplus64 gives error (oracle client 11g)
sqlplus64 gives error [message #571811] Fri, 30 November 2012 14:16 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
I am having trouble using sqlplus in ubuntu.

I installed oracle client as per instruction from https://help.ubuntu.com/community/Oracle%20Instant%20Client.

I get error message when I run sqlplus64
/usr/lib/oracle/11.2/client64/lib$ sqlplus64
sqlplus64: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory


this is my env


TERM=ansi
SHELL=/bin/bash
XDG_SESSION_COOKIE=243b07bfe19630e38276c43800000005-1354303599.618899-903387366
SSH_CLIENT=10.20.53.2 1239 22
OLDPWD=/usr/lib/oracle/11.2
SSH_TTY=/dev/pts/0
USER=acf
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;3
1:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*
.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01
;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:
*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;
35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.r
a=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:
MAIL=/var/mail/acf
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
LC_MESSAGES=en_US.UTF-8
LC_COLLATE=en_US.UTF-8
PWD=/usr/lib/oracle/11.2/client64/lib
JAVA_HOME=/opt/jdk1.6.0_35
LANG=en_US.UTF-8
SHLVL=1
HOME=/home/acf
LANGUAGE=en_US:en
LOGNAME=acf
LC_CTYPE=en_US.UTF-8
SSH_CONNECTION=10.20.53.2 1239 10.20.50.175 22
LESSOPEN=| /usr/bin/lesspipe %s
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LESSCLOSE=/usr/bin/lesspipe %s %s
_=/usr/bin/env



Please help me.
Re: sqlplus64 gives error [message #571812 is a reply to message #571811] Fri, 30 November 2012 14:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Oracle is not certified on Ubuntu.

what gets returned by long running OS command below

find / -name libclntsh\* 2>/dev/null
Re: sqlplus64 gives error [message #571813 is a reply to message #571812] Fri, 30 November 2012 14:26 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
sudo find / -name libclntsh\* 2>/dev/null returned

/opt/oracle-instantclient11.2-basic-11.2.0.3.0/debian/oracle-instantclient11.2-basic/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1
/opt/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1
/usr/lib/oracle/11.2/client64/lib/libclntsh.so
/home/acf/oracle-instantclient11.2-basic-11.2.0.3.0/debian/oracle-instantclient11.2-basic/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1
/home/acf/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1
/home/acf/Oracle/Middleware/wlserver_10.3/server/adr/libclntsh.so.11.1

Re: sqlplus64 gives error [message #571814 is a reply to message #571813] Fri, 30 November 2012 14:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>sqlplus64: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
the file it wants does not reside in/under LD_LIBRARY_PATH
Re: sqlplus64 gives error [message #571815 is a reply to message #571814] Fri, 30 November 2012 14:44 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
files inside /usr/lib/oracle/11.2/client64/lib


drwxr-xr-x 2 root root    4096 2012-10-16 17:39 ./
drwxr-xr-x 4 root root    4096 2012-10-16 17:39 ../
-rw-r--r-- 1 root root     368 2011-09-17 11:08 glogin.sql
lrwxrwxrwx 1 root root      17 2012-10-16 17:39 libclntsh.so -> libclntsh.so.11.1
lrwxrwxrwx 1 root root      15 2012-10-16 17:39 libocci.so -> libocci.so.11.1
-rw-r--r-- 1 root root 1503303 2011-09-17 11:08 libsqlplusic.so
-rw-r--r-- 1 root root 1477446 2011-09-17 11:08 libsqlplus.so
-rw-r--r-- 1 root root  300666 2011-09-17 11:08 ottclasses.zip

Re: sqlplus64 gives error [message #571816 is a reply to message #571814] Fri, 30 November 2012 14:59 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
Please tell me where can I download these files ?
Re: sqlplus64 gives error [message #571818 is a reply to message #571816] Fri, 30 November 2012 15:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
libclntsh.so.11.1 does not reside in/under LD_LIBRARY_PATH

>Please tell me where can I download these files ?
list & enumerate "these files"
Re: sqlplus64 gives error [message #571879 is a reply to message #571818] Mon, 03 December 2012 09:02 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
I don't understand what you mean by
list & enumerate "these files"


I am not unix expert and not dba ,Please help me.
Re: sqlplus64 gives error [message #571887 is a reply to message #571879] Mon, 03 December 2012 09:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
consider doing as below

cp /opt/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 /usr/lib/oracle/11.2/client64/lib/
chmod 777 /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1
Re: sqlplus64 gives error [message #572159 is a reply to message #571887] Thu, 06 December 2012 10:41 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
BlackSwan wrote on Mon, 03 December 2012 10:38
consider doing as below

cp /opt/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 /usr/lib/oracle/11.2/client64/lib/
chmod 777 /usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1

I did this , getting new error

sqlplus64: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory
Re: sqlplus64 gives error [message #572161 is a reply to message #572159] Thu, 06 December 2012 10:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from OS command below

sudo find / -name libnnz\* 2>/dev/null

[Updated on: Thu, 06 December 2012 10:46]

Report message to a moderator

Re: sqlplus64 gives error [message #572167 is a reply to message #572161] Thu, 06 December 2012 11:42 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
BlackSwan wrote on Thu, 06 December 2012 11:46
post results from OS command below

sudo find / -name libnnz\* 2>/dev/null



/opt/oracle-instantclient11.2-basic-11.2.0.3.0/debian/oracle-instantclient11.2-basic/usr/lib/oracle/11.2/client64/lib/libnnz11.so
/opt/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib/libnnz11.so
/home/acf/oracle-instantclient11.2-basic-11.2.0.3.0/debian/oracle-instantclient11.2-basic/usr/lib/oracle/11.2/client64/lib/libnnz11.so
/home/acf/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib/libnnz11.so
/home/acf/Oracle/Middleware/wlserver_10.3/server/adr/libnnz11.so

Re: sqlplus64 gives error [message #572168 is a reply to message #572167] Thu, 06 December 2012 11:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib
Re: sqlplus64 gives error [message #572169 is a reply to message #572168] Thu, 06 December 2012 12:02 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
BlackSwan wrote on Thu, 06 December 2012 12:55
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle-instantclient11.2-basic-11.2.0.3.0/usr/lib/oracle/11.2/client64/lib

got this


acf@ACFUbuntu01:~$ sqlplus64 
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
Re: sqlplus64 gives error [message #572170 is a reply to message #572169] Thu, 06 December 2012 12:07 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Since you are using unsupported Unbuntu, You're On Your Own!
01503,0, "Unable to initialize Oracle call interface\n"
// *Cause:  Indicates a library used by SQL*Plus to communicate with
//          the database failed to initialize correctly.
// *Action: Check that the Oracle environment or registry entries are
//          consistent and correct.  If using the SQL*Plus Instant Client
//          make sure the SQL*Plus and Oracle libraries are from the
//          same release. Make sure you have read access to the libraries.
[oracle@localhost ~]$ oerr sp2 152
00152,0, "ORACLE may not be functioning properly\n"
// *Cause:  Unable to initialize a session to the Oracle instance.
// *Action: Make a note of the message and the number, then contact
//          the Database Administrator.
Previous Topic: Getting error while connecting to DB in PL/SQL developer.
Next Topic: Not able to connect from client to Oracle Database in Unix
Goto Forum:
  


Current Time: Tue Apr 16 15:40:10 CDT 2024