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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

[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: 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

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 =>  (0xb771f000) => /u01/app/oracle/product/11/lib/ (0xb766e000) => not found => /u01/app/oracle/product/11/lib/ (0xb7415000) => /lib/ (0x4c5dc000) => /lib/ (0x4c616000) => /lib/ (0x4c5e3000) => /lib/ (0x4caef000) => /lib/ (0x4c44a000)  
    /lib/ (0x4c424000) => not found   

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

$ ldd /u01/app/oracle/product/11/bin/sqlplus =>  (0xb7831000) => /u01/app/oracle/product/11/lib/ (0xb7780000) => /u01/app/oracle/product/11/lib/ (0xb5a7b000) => /u01/app/oracle/product/11/lib/ (0xb582e000) => /lib/ (0x4c5dc000) => /lib/ (0x4c616000) => /lib/ (0x4c5e3000) => /lib/ (0x4caef000) => /lib/ (0x4c44a000) => /lib/ (0x4c446000)  
/lib/ (0x4c424000)  

Any idea why SQLPlus is complaining about

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

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 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. – Phil Feb 1 '12 at 13:42
@phil 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" ? – Phil 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.