Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

[question copied from stackoverflow]

After installation of Oracle 11.2g in silent mode on the Oracle Linux kernel, I have the following error:

[u01/app/oracle/product/11/bin] $ sqlplus

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

However, the shared object seems to be setup correctly:

[/u01/app/oracle/product/11/lib] $ ls -lrt /u01/app/oracle/product/11/lib | grep sqlplus  
-rw-r--r--. 1 oracle oinstall   1475820 Aug  1  2009 libsqlplus.a  
-rwxr-xr-x. 1 oracle oinstall   1218075 Aug  1  2009 libsqlplus.so

The user is oracle:

[oracle ~]$ id oracle  
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)

The environment variables are:

[oracle ~]$ env  
    :/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin: /home/oracle/bin

kernel version:



[oracle@orcus lib]$ ldd /u01/app/oracle/product/11/bin/sqlplus   
    linux-gate.so.1 =>  (0xb771f000)  
    libsqlplus.so => /u01/app/oracle/product/11/lib/libsqlplus.so (0xb766e000)  
libclntsh.so.11.1 => not found  
    libnnz11.so => /u01/app/oracle/product/11/lib/libnnz11.so (0xb7415000)  
    libdl.so.2 => /lib/libdl.so.2 (0x4c5dc000)  
    libm.so.6 => /lib/libm.so.6 (0x4c616000)  
    libpthread.so.0 => /lib/libpthread.so.0 (0x4c5e3000)  
    libnsl.so.1 => /lib/libnsl.so.1 (0x4caef000)  
    libc.so.6 => /lib/libc.so.6 (0x4c44a000)  
    /lib/ld-linux.so.2 (0x4c424000)  
    libclntsh.so.11.1 => not found   

* after chmod /u01/app/oracle/product/11/lib/libclntsh* *

$ ldd /u01/app/oracle/product/11/bin/sqlplus   
    linux-gate.so.1 =>  (0xb7831000)  
    libsqlplus.so => /u01/app/oracle/product/11/lib/libsqlplus.so (0xb7780000)  
    libclntsh.so.11.1 => /u01/app/oracle/product/11/lib/libclntsh.so.11.1 (0xb5a7b000)  
    libnnz11.so => /u01/app/oracle/product/11/lib/libnnz11.so (0xb582e000)  
    libdl.so.2 => /lib/libdl.so.2 (0x4c5dc000)  
    libm.so.6 => /lib/libm.so.6 (0x4c616000)  
    libpthread.so.0 => /lib/libpthread.so.0 (0x4c5e3000)  
    libnsl.so.1 => /lib/libnsl.so.1 (0x4caef000)  
    libc.so.6 => /lib/libc.so.6 (0x4c44a000)  
    libaio.so.1 => /lib/libaio.so.1 (0x4c446000)  
/lib/ld-linux.so.2 (0x4c424000)  

Any idea why SQLPlus is complaining about libsqlplus.so?

share|improve this question
Please post the output of "ldd /u01/app/oracle/product/11/bin/sqlplus" –  tblPhil Feb 1 '12 at 11:16
@phil, please find the file in my update –  user1182411 Feb 1 '12 at 13:29

2 Answers 2

Make libclntsh executable:

chmod +rx /u01/app/oracle/product/11/lib/libclntsh*

Then check the above commented ldd command again.

share|improve this answer

You should be searching for libclntsh.so.11.1 in /u01/app/oracle/product/11/lib ,

share|improve this answer
Are you sure the silent install completed? The library should also be in $ORACLE_HOME/lib. Check the silent install log file. –  tblPhil Feb 1 '12 at 13:42
@phil libclntsh.so.11.1 found after mod changed –  user1182411 Feb 1 '12 at 13:43
@phil found one silent install log file called : silentInstall2012-01-24_06-14-37PM.log actually full of errors. But now the $ sqlplus /nolog worked, but denied access to sqlplus /as sysdba –  user1182411 Feb 1 '12 at 14:19
What's the error message when you "sqlplus / as sysdba" ? –  tblPhil Feb 1 '12 at 14:49
@phil ERROR: ORA-12547: TNS:lost contact but it gave me the prompt to log and no user name and password already set in the response file match –  user1182411 Feb 1 '12 at 14:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.