3

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  
USER=oracle  
LD_LIBRARY_PATH=/u01/app/oracle/product/11/lib  
ORACLE_SID=orcl  
ORACLE_BASE=/u01/app/oracle      
PATH=/usr/lib/qt-3.3/bin:/usr/local/bin
    :/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin: /home/oracle/bin
    :/u01/app/oracle/product/11/bin  
HOME=/home/oracle  
ORACLE_HOME=/u01/app/oracle/product/11  

kernel version:

2.6.32-300.3.1.el6uek.i686

*UPDATE FOR ANSWER *

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

2

Make libclntsh executable:

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

Then check the above commented ldd command again.

0

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

  • 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 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" ? – 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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