Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2014
    Posts
    7

    Unanswered: Oracle on Linux (Ubuntu), SQLPlus won't work.

    Hello there,

    DISTRIB_ID=Ubuntu
    DISTRIB_RELEASE=10.04
    DISTRIB_CODENAME=lucid
    DISTRIB_DESCRIPTION="Ubuntu 10.04.2 LTS"
    2.6.32-28-generic

    I installed Oracle 11gR2 (32bit) on Linux Ubuntu 10.04 (without X-Serv), which worked fine.
    But when I try to start SQLPlus, I receive the following error message:

    sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

    I have set the LD_LIBRARY_PATH again manually, but didn't fix the error:
    oracle@ubuntu:~$ echo $LD_LIBRARY_PATH
    /opt/oracle/product/ora11gR2/lib


    Can anybody help?

    Thanks

    Marc




    oracle@ubuntu:~$ env | sort
    DISPLAY=localhost:10.0
    EDITOR=nano -nw
    HOME=/home/oracle
    LANG=en_US.UTF-8
    LC_MESSAGES=C
    LD_LIBRARY_PATH=/opt/oracle/product/ora11gR2/lib
    LESSCLOSE=/usr/bin/lesspipe %s %s
    LESSOPEN=| /usr/bin/lesspipe %s
    LOGNAME=oracle
    LS_COLORS=rs=0:di=01;34:ln=01;36:hl=44;37i=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01r=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42w=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31: *.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:* .zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01; 31:*.bz2=01;31:*.bz=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;3 5:*.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:*.n uv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb =01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=0 1;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35 :*.yuv=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:* .ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.m id=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mp c=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=0 0;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:
    MAIL=/var/mail/oracle
    ORACLE_BASE=/opt/oracle/product
    ORACLE_HOME=/opt/oracle/product/ora11gR2
    ORACLE_SID=ORADB1
    ORACLE_TERM=xterm
    PATH=/opt/oracle/product/ora11gR2/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
    PWD=/home/oracle
    SHELL=/bin/bash
    SHLVL=1
    SSH_CLIENT=192.168.2.20 53964 22
    SSH_CONNECTION=192.168.2.20 53964 192.168.2.21 22
    SSH_TTY=/dev/pts/0
    TERM=xterm
    TNS_ADMIN=/opt/oracle/product/ora11gR2/network/admin
    USER=oracle
    _=/usr/bin/env
    VISUAL=nano -nw




    oracle@ubuntu:~$ find / -name libclntsh.so\* -ls 2>/dev/null
    664323 0 -rw-r--r-- 1 oracle oinstall 0 Nov 6 12:35 /opt/oracle/product/ora11gR2/lib/libclntsh.so
    790960 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/backup/2014-11-06_12-32-02PM/Scripts/ext/lib/libclntsh.so.11.1
    790677 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/Scripts/ext/lib/libclntsh.so.11.1
    524991 39152 -rwxr-xr-x 1 oracle root 40088477 Nov 6 12:15 /home/oracle/database/stage/ext/lib/libclntsh.so.11.1
    Last edited by marcreg; 11-06-14 at 11:06.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    1) UBUNTU is not a support OS

    post results from following OS command

    find / -name libclntsh.so\* -ls 2>/dev/null
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2014
    Posts
    7
    Thanks for your reply.

    oracle@ubuntu:~$ find / -name libclntsh.so\* -ls 2>/dev/null
    664323 0 -rw-r--r-- 1 oracle oinstall 0 Nov 6 12:35 /opt/oracle/product/ora11gR2/lib/libclntsh.so
    790960 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/backup/2014-11-06_12-32-02PM/Scripts/ext/lib/libclntsh.so.11.1
    790677 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/Scripts/ext/lib/libclntsh.so.11.1
    524991 39152 -rwxr-xr-x 1 oracle root 40088477 Nov 6 12:15 /home/oracle/database/stage/ext/lib/libclntsh.so.11.1

  4. #4
    Join Date
    Nov 2014
    Posts
    7
    oracle@ubuntu:~$ find / -name libclntsh.so\* -ls 2>/dev/null
    664323 0 -rw-r--r-- 1 oracle oinstall 0 Nov 6 12:35 /opt/oracle/product/ora11gR2/lib/libclntsh.so
    790960 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/backup/2014-11-06_12-32-02PM/Scripts/ext/lib/libclntsh.so.11.1
    790677 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/Scripts/ext/lib/libclntsh.so.11.1
    524991 39152 -rwxr-xr-x 1 oracle root 40088477 Nov 6 12:15 /home/oracle/database/stage/ext/lib/libclntsh.so.11.1

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post results from following OS command

    env | sort
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Nov 2014
    Posts
    7
    oracle@ubuntu:~$ env | sort
    DISPLAY=localhost:10.0
    EDITOR=nano -nw
    HOME=/home/oracle
    LANG=en_US.UTF-8
    LC_MESSAGES=C
    LD_LIBRARY_PATH=/opt/oracle/product/ora11gR2/lib
    LESSCLOSE=/usr/bin/lesspipe %s %s
    LESSOPEN=| /usr/bin/lesspipe %s
    LOGNAME=oracle
    LS_COLORS=rs=0:di=01;34:ln=01;36:hl=44;37i=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01r=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42w=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31: *.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:* .zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01; 31:*.bz2=01;31:*.bz=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;3 5:*.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:*.n uv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb =01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=0 1;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35 :*.yuv=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:* .ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.m id=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mp c=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=0 0;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:
    MAIL=/var/mail/oracle
    ORACLE_BASE=/opt/oracle/product
    ORACLE_HOME=/opt/oracle/product/ora11gR2
    ORACLE_SID=ORADB1
    ORACLE_TERM=xterm
    PATH=/opt/oracle/product/ora11gR2/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
    PWD=/home/oracle
    SHELL=/bin/bash
    SHLVL=1
    SSH_CLIENT=192.168.2.20 53964 22
    SSH_CONNECTION=192.168.2.20 53964 192.168.2.21 22
    SSH_TTY=/dev/pts/0
    TERM=xterm
    TNS_ADMIN=/opt/oracle/product/ora11gR2/network/admin
    USER=oracle
    _=/usr/bin/env
    VISUAL=nano -nw

  7. #7
    Join Date
    Nov 2014
    Posts
    7

    sorry for any double posts, but somehow the forum is not showing my replies?

    oracle@ubuntu:~$ find / -name libclntsh.so\* -ls 2>/dev/null
    664323 0 -rw-r--r-- 1 oracle oinstall 0 Nov 6 12:35 /opt/oracle/product/ora11gR2/lib/libclntsh.so
    790960 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/backup/2014-11-06_12-32-02PM/Scripts/ext/lib/libclntsh.so.11.1
    790677 39152 -rwxrwx--- 1 oracle oinstall 40088477 Nov 6 12:32 /opt/oracle/product/ora11gR2/inventory/Scripts/ext/lib/libclntsh.so.11.1
    524991 39152 -rwxr-xr-x 1 oracle root 40088477 Nov 6 12:15 /home/oracle/database/stage/ext/lib/libclntsh.so.11.1



    oracle@ubuntu:~$ env | sort
    DISPLAY=localhost:10.0
    EDITOR=nano -nw
    HOME=/home/oracle
    LANG=en_US.UTF-8
    LC_MESSAGES=C
    LD_LIBRARY_PATH=/opt/oracle/product/ora11gR2/lib
    LESSCLOSE=/usr/bin/lesspipe %s %s
    LESSOPEN=| /usr/bin/lesspipe %s
    LOGNAME=oracle
    LS_COLORS=rs=0:di=01;34:ln=01;36:hl=44;37i=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01r=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42w=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31: *.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:* .zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01; 31:*.bz2=01;31:*.bz=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;3 5:*.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:*.n uv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb =01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=0 1;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35 :*.yuv=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:* .ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.m id=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mp c=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=0 0;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:
    MAIL=/var/mail/oracle
    ORACLE_BASE=/opt/oracle/product
    ORACLE_HOME=/opt/oracle/product/ora11gR2
    ORACLE_SID=ORADB1
    ORACLE_TERM=xterm
    PATH=/opt/oracle/product/ora11gR2/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
    PWD=/home/oracle
    SHELL=/bin/bash
    SHLVL=1
    SSH_CLIENT=192.168.2.20 53965 22
    SSH_CONNECTION=192.168.2.20 53965 192.168.2.21 22
    SSH_TTY=/dev/pts/0
    TERM=xterm
    TNS_ADMIN=/opt/oracle/product/ora11gR2/network/admin
    USER=oracle
    _=/usr/bin/env
    VISUAL=nano -nw

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >oracle@ubuntu:~$ find / -name libclntsh.so\* -ls 2>/dev/null
    >664323 0 -rw-r--r-- 1 oracle oinstall 0 Nov 6 12:35 /opt/oracle/product/ora11gR2/lib/libclntsh.so

    problem results when file above has ZERO length
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Nov 2014
    Posts
    7
    Quote Originally Posted by anacedent View Post
    >oracle@ubuntu:~$ find / -name libclntsh.so\* -ls 2>/dev/null
    >664323 0 -rw-r--r-- 1 oracle oinstall 0 Nov 6 12:35 /opt/oracle/product/ora11gR2/lib/libclntsh.so

    problem results when file above has ZERO length

    So what is the solution then? And why is it an empty file? Package corrupted?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •