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

Error:

 Post Client installation receiving error as 

 [oracle@testlaba ~]$ sqlplus "/ as sysdba"

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





Possible Cause:

i.  Incomplete installation 
ii. Missing library files
iii. Missing prerequisites OS packages
iv. In appropriate environment setting 
Will go through steps to troubleshoot the issue to get resolution 






Troubleshooting:

i.  OS level command Tracing 
[oracle@testlaba ~]$ strace sqlplus "/ as sysdba"
execve("/rdbms/app/12.1.0.2/bin/sqlplus", ["sqlplus", "/ as sysdba"], [/* 30 vars */]) = 0
brk(0)                                  = 0xab0000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe27ec7b000
access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory)
open("/rdbms/app/12.1.0.2/lib/tls/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/rdbms/app/12.1.0.2/lib/tls/x86_64", 0x7fff731bb930) = -1 ENOENT (No such file or directory)
open("/rdbms/app/12.1.0.2/lib/tls/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/rdbms/app/12.1.0.2/lib/tls", 0x7fff731bb930) = -1 ENOENT (No such file or directory)
open("/rdbms/app/12.1.0.2/lib/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/rdbms/app/12.1.0.2/lib/x86_64", 0x7fff731bb930) = -1 ENOENT (No such file or directory)
open("/rdbms/app/12.1.0.2/lib/libsqlplus.so", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\320\374\1\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=1546540, ...}) = 0
mmap(NULL, 3112424, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe27e983000
mprotect(0x7fe27ea6d000, 2093056, PROT_NONE) = 0
mmap(0x7fe27ec6c000, 61440, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe9000) = 0x7fe27ec6c000
close(3)                                = 0
open("/rdbms/app/12.1.0.2/lib/libclntsh.so.12.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\233N\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=58793741, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe27e982000
mmap(NULL, 50056080, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe27b9c5000
mprotect(0x7fe27e580000, 2097152, PROT_NONE) = 0
mmap(0x7fe27e780000, 1974272, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2bbb000) = 0x7fe27e780000
mmap(0x7fe27e962000, 129936, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe27e962000
mprotect(0x7fff731bc000, 4096, PROT_READ|PROT_WRITE|PROT_EXEC|PROT_GROWSDOWN) = 0
close(3)                                = 0
open("/rdbms/app/12.1.0.2/lib/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=40181, ...}) = 0
mmap(NULL, 40181, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fe27b9bb000
close(3)                                = 0
open("/lib64/tls/x86_64/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib64/tls/x86_64", 0x7fff731bb8d0) = -1 ENOENT (No such file or directory)
open("/lib64/tls/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib64/tls", {st_mode=S_IFDIR|0555, st_size=4096, ...}) = 0
open("/lib64/x86_64/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib64/x86_64", 0x7fff731bb8d0)   = -1 ENOENT (No such file or directory)
open("/lib64/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib64", {st_mode=S_IFDIR|0555, st_size=12288, ...}) = 0
open("/usr/lib64/tls/x86_64/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib64/tls/x86_64", 0x7fff731bb8d0) = -1 ENOENT (No such file or directory)
open("/usr/lib64/tls/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib64/tls", {st_mode=S_IFDIR|0555, st_size=4096, ...}) = 0
open("/usr/lib64/x86_64/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib64/x86_64", 0x7fff731bb8d0) = -1 ENOENT (No such file or directory)
open("/usr/lib64/libclntshcore.so.12.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib64", {st_mode=S_IFDIR|0555, st_size=36864, ...}) = 0
writev(2, [{"sqlplus", 7}, {": ", 2}, {"error while loading shared libra"..., 36}, {": ", 2}, {"libclntshcore.so.12.1", 21}, {": ", 2}, {"cannot open shared object file", 30}, {": ", 2}, {"No such file or directory", 25}, {"\n", 1}], 10sqlplus: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
) = 128
exit_group(127)                         = ?

+++ exited with 127 +++

 It looks like missing lib files post installation , let's search for missing lib files



ii. In Search if missing library file

[oracle@testlaba ]$ cd $ORACLE_HOME/lib

 [oracle@testlaba lib]$ ls -lrt
total 418140
-rw-r--r--. 1 oracle oracle    56899 Sep 25  2000 jdev-rt.zip
-rw-r--r--. 1 oracle oracle   280984 Oct 23  2001 mail.jar
-rw-r--r--. 1 oracle oracle    45386 Oct 23  2001 activation.jar
-rw-r--r--. 1 oracle oracle    37948 Jun  9  2006 jcr-1.0.jar
-rw-------. 1 oracle oracle   408282 Nov  8  2011 libexpat.so.1.5.2
-rw-------. 1 oracle oracle   408282 Nov  8  2011 libexpat.so.1
-rw-------. 1 oracle oracle   408282 Nov  8  2011 libexpat.so
-rw-------. 1 oracle oracle      793 Nov  8  2011 libexpat.la
-rw-------. 1 oracle oracle   617772 Nov  8  2011 libexpat.a
-rw-r--r--. 1 oracle oracle   358124 Jan 31  2013 libwwg.a
-rw-r--r--. 1 oracle oracle        0 Oct 17  2013 clntsh.map
-rw-r--r--. 1 oracle oracle   812074 Nov 14  2013 libccme_ecc_accel_fips.so
-rw-r--r--. 1 oracle oracle   129660 Dec  3  2013 libipp_z.a
-rw-r--r--. 1 oracle oracle 47924222 Dec  3  2013 libippsmerged.a
-rw-r--r--. 1 oracle oracle  4971338 Dec  3  2013 libippsemerged.a
-rw-r--r--. 1 oracle oracle  2652644 Dec  3  2013 libippdcmerged.a
-rw-r--r--. 1 oracle oracle   339570 Dec  3  2013 libippdcemerged.a
-rw-r--r--. 1 oracle oracle   103952 Dec  3  2013 libippcore.a
-rw-r--r--. 1 oracle oracle   116302 Dec  3  2013 libipp_bz2.a
-rw-r--r--. 1 oracle oracle   445946 Jan  2  2014 libcryptocme.so
-rw-r--r--. 1 oracle oracle     2638 Jan  2  2014 libcryptocme.sig
-rw-r--r--. 1 oracle oracle   709631 Jan  2  2014 libccme_ecc.so
-rw-r--r--. 1 oracle oracle   555820 Jan  2  2014 libccme_base.so
-rw-r--r--. 1 oracle oracle   415660 Jan  2  2014 libccme_asym.so
-rw-r--r--. 1 oracle oracle   461494 May  6  2014 libccme_ecc_non_fips.so
-rw-r--r--. 1 oracle oracle    91568 Jun 18  2014 libowm2.so
-rw-r--r--. 1 oracle oracle    75510 Jun 18  2014 libldapjclnt12.so
-rw-r--r--. 1 oracle oracle 20829764 Jun 18  2014 libnnzst12.a
-rw-r--r--. 1 oracle oracle  2457778 Jun 18  2014 libipc1.a
-rw-r--r--. 1 oracle oracle   666598 Jun 18  2014 libmql1.a
-rw-r--r--. 1 oracle oracle   544150 Jun 18  2014 libmql1.so
-rw-r--r--. 1 oracle oracle  1768370 Jun 18  2014 libipc1.so
-rw-r--r--. 1 oracle oracle   265906 Jun 19  2014 libunls12.a
-rw-r--r--. 1 oracle oracle   356272 Jun 19  2014 libsnls12.a
-rw-r--r--. 1 oracle oracle  2919180 Jun 19  2014 libnls12.a
-rw-r--r--. 1 oracle oracle   120118 Jun 19  2014 liblxled.a
-rw-r--r--. 1 oracle oracle   197030 Jun 26  2014 libncrypt12.a
-rw-r--r--. 1 oracle oracle     5784 Jun 26  2014 nautab.o
-rw-r--r--. 1 oracle oracle   353883 Jun 26  2014 ojcr.jar
-rw-r--r--. 1 oracle oracle  1540260 Jun 27  2014 libnl12.a
-rw-r--r--. 1 oracle oracle 11448910 Jun 27  2014 libxml12.a
-rw-r--r--. 1 oracle oracle    40130 Jun 27  2014 libntns12.a
-rw-r--r--. 1 oracle oracle    29204 Jun 27  2014 libnhost12.a
-rw-r--r--. 1 oracle oracle    13162 Jun 27  2014 libnoname12.a
-rw-r--r--. 1 oracle oracle   329216 Jun 27  2014 libnldap12.a
-rw-r--r--. 1 oracle oracle   203755 Jun 27  2014 xsu12.jar
-rw-r--r--. 1 oracle oracle   596274 Jun 27  2014 xml.jar
-rw-r--r--. 1 oracle oracle    97280 Jun 27  2014 xmlcomp.jar
.
.
.
.
-rw-r--r--. 1 oracle oracle    96003 Jul  7  2014 libnfsodm12.so
-rw-r--r--. 1 oracle oracle  2576030 Jul  7  2014 libocci.so.12.1
-rw-r--r--. 1 oracle oracle   406094 Jul  7  2014 libxdb.so
-rw-r--r--. 1 oracle oracle  1670948 Jul  7  2014 libasmclntsh12.so
-rw-r--r--. 1 oracle oracle  1135218 Jul  7  2014 libskgxpg.so
-rw-r--r--. 1 oracle oracle  1135218 Jul  7  2014 libskgxp12.so
-rw-r--r--. 1 oracle oracle    10046 Jul  7  2014 libvsn12_std.a.dbl
-rw-r--r--. 1 oracle oracle    10070 Jul  7  2014 libvsn12_cse.a.dbl
-rw-r--r--. 1 oracle oracle    10078 Jul  7  2014 libvsn12_cee.a.dbl
-rw-r--r--. 1 oracle oracle    10030 Jul  7  2014 libvsn12.a
-rw-r--r--. 1 oracle oracle    13906 Jul  7  2014 libskgxn2.so
-rw-r--r--. 1 oracle oracle  2530064 Jul  7  2014 libagtsh.so.1.0
-rw-r--r--. 1 oracle oracle  6791124 Jul  7  2014 libcell12.so
-rw-r--r--. 1 oracle oracle        0 Jul  7  2014 libclntst12.a
drwxr-xr-x. 2 oracle oracle     4096 Jul 19 12:59 stubs
lrwxrwxrwx. 1 oracle oracle       15 Jul 19 13:00 libocci.so -> libocci.so.12.1
lrwxrwxrwx. 1 oracle oracle       15 Jul 19 13:00 libagtsh.so -> libagtsh.so.1.0
lrwxrwxrwx. 1 oracle oracle       41 Jul 19 13:00 libclntsh.so -> /rdbms/app/12.1.0.2/lib/libclntsh.so.12.1
-rw-r--r--. 1 oracle oracle      115 Jul 19 13:22 ldflagsO
-rw-r--r--. 1 oracle oracle      115 Jul 19 13:22 ldflags
-rw-r--r--. 1 oracle oracle     2512 Jul 19 13:22 ntcontab.o
-rw-r--r--. 1 oracle oracle     1968 Jul 19 13:22 nnfgt.o
-rw-r--r--. 1 oracle oracle  9169174 Jul 19 13:22 libn12.a
-rw-r--r--. 1 oracle oracle        0 Jul 19 13:22 clntshcore.map
[oracle@testlaba lib]$ pwd
/rdbms/app/12.1.0.2/lib
[oracle@testlaba lib]$ pwd
/rdbms/app/12.1.0.2/lib
[oracle@testlaba lib]$ sqlplus -c
sqlplus: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
[oracle@testlaba lib]$ ls -lrt libclntshcore.so.12.1
ls: cannot access libclntshcore.so.12.1: No such file or directory
[oracle@testlaba lib]$ sudo -l
[sudo] password for oracle:
Matching Defaults entries for oracle on this host:
    logfile=/var/log/sudolog, timestamp_timeout=30, tty_tickets, env_delete+=SUDO_USER
User oracle may run the following commands on this host:
    (root) ALL
[oracle@testlaba lib]$ sudo find -name "libclntshcore.so.12.1"
[oracle@testlaba lib]$ sudo find / -name "libclntshcore.so.12.1"

[oracle@testlaba lib]$ pwd

/rdbms/app/12.1.0.2/lib

No Luck , Can't find the missing lib


2 comments:

  1. vinayakAugust 23, 2018 at 12:02 PM

    i resolved this by copying the libclntshcore.so.12.1 file manually to /product//lib/ path.

    ReplyDelete
  2. M.Asif khanMay 24, 2021 at 7:59 PM

    Thanks vinayak,
    I also resolved by copying manually

    ReplyDelete