R12.2 adcfgclone fails with libclntsh.so.10.1 error

~ aninditakar

During a cloning operation in R12.2 and subsequent execution of perl adcfgclone.pl appsTier dualfs, the operation failed with the following error:

/ebs/R122/fs1/EBSapps/10.1.2/bin/sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

As per the Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1), the issue is documented under KNOWN ISSUES.

Known Issue:

Certain versions of binutils, such as 2.26 and 2.27-27 in RHEL/OL 7, introduced a regression that causes the following failure with a relinked sqlplus (after a clone operation, for example):

[oracle@apps lib]$ sqlplus <APPS LOGIN>/<APPS PASSWORD>  
sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open   
shared object file: No such file or directory

The reported version is:

[root@hostname rpm]# rpm -qa --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep binutils
binutils-2.27-44.base.el7_9.1.x86_64

This regression was addressed starting from version 2.27-28 in RHEL/OL 7. Users encountering the above failure are advised to upgrade binutils to at least version 2.27-28. However, that did not help with the issue.

Steps undertaken:

  1. Downgraded binutils version to binutils-2.23.52.0.1-16.el7.x86_64.rpm following Doc ID 2390797.1, but the error persisted.
  2. Upgraded binutils version again to binutils-2.27-44.base.el7_9.1.x86_64.
  3. Provided requested files to Oracle Support:
    a. EBS Cloning Analyzer: Uploaded the EBS Cloning Analyzer output zip file (CLONEHA_<DATE>_<TIME>.zip) as per instructions in note E-Business Suite Cloning Analyzer (Doc ID 2379649.1).
    b. EBS Cloning DB Analyzer: Uploaded the EBS Cloning Database Analyzer output zip-file following the instructions in note EBS Cloning Analyzer (Doc ID 2379649.1).
  4. After thorough investigation, it was identified that glibc-devel-2.17-325.el7_9.i686 was missing.

The resolution involved a simple fix – “yum install glibc-devel.i686,” followed by rerunning adcfgclone.

Leave a comment