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?

Paul White
95.4k30 gold badges440 silver badges689 bronze badges
asked Feb 1, 2012 at 11:02
0

2 Answers 2

2

Make libclntsh executable:

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

Then check the above commented ldd command again.

answered Feb 1, 2012 at 13:32
0

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

answered Feb 1, 2012 at 13:22
6
  • Are you sure the silent install completed? The library should also be in $ORACLE_HOME/lib. Check the silent install log file. Commented Feb 1, 2012 at 13:42
  • @phil libclntsh.so.11.1 found after mod changed Commented Feb 1, 2012 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 Commented Feb 1, 2012 at 14:19
  • What's the error message when you "sqlplus / as sysdba" ? Commented Feb 1, 2012 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 Commented Feb 1, 2012 at 14:59

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.