Issue:
sqlplus and rman and other binary executable are not working with error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
Error Message:
/orasw/oracle/product/12.1.0.2/db/bin/sqlplus: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
/orasw/oracle/product/12.1.0.2/db/bin/rman: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
[oracle@oracledb lib]$ sqlplus / as sysdba
sqlplus: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
[oracle@oracledb lib]$ rman target /
rman: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
[oracle@oracledb lib]$
Cause:
After Inverstigating found that the shared object file libclntshcore.so.12.1 was missing from the lib(/orasw/oracle/product/12.1.0.2/db/lib) location.
Solution:
[oracle@oracledb lib]$ pwd
/u01/app/oracle/product/12.2.0.1/dbhome_1/lib
[oracle@oracledb lib]$ ls -lrtr libclntshcore.so.12.1
ls: cannot access libclntshcore.so.12.1: No such file or directory
[oracle@oracledb lib]$
Copy from the existing Oracle Home and verify the file exist and has proper permission
[oracle@oracledb lib]$ ls -lrtr libclntshcore.so.12.1
-rwxr-xr-x. 1 oracle oinstall 8032696 Sep 27 19:28 libclntshcore.so.12.1
[oracle@oracledb lib]$
[oracle@oracledb lib]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 27 19:29:18 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@oracledb lib]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Mon Sep 27 19:29:24 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA12C (DBID=457334020)
RMAN>
Recovery Manager complete.
[oracle@oracledb lib]$
Regards,
Mallik
