How to troubleshoot the error "loading shared library libclntsh.so: No such file or directory"

How to troubleshoot the error "loading shared library libclntsh.so: No such file or directory"

book

Article ID: KB0071671

calendar_today

Updated On:

Products Versions
TIBCO Flogo Connector for Oracle Database all supported versions

Description

Users could see the below error when testing an app with TIBCO Flogo Connector for Oracle Database on Flogo Enterprise or TIBCO Cloud:
======================================
Failed to create engine instance due to error: Failed to connect to Oracle Database due to error - [ORA-00000: DPI-1047: Cannot locate a 64-bit Oracle Client library: "Error loading shared library libclntsh.so: Exec format error".
======================================

Issue/Introduction

How to troubleshoot the error "loading shared library libclntsh.so: No such file or directory"

Environment

Product: TIBCO Flogo Connector for Oracle Database Version: all supported versions OS: TIBCO Cloud and Flogo Enterprise

Resolution

This error happens because the connector could not find the Oracle client libraries.
TIBCO Flogo Connector for Oracle Database requires Oracle client libraries to function. It is needed to supplement the Oracle client libraries to the Oracle Database Connector.

For the Flogo Enterprise environment, please refer to the below doc:
https://docs.tibco.com/pub/flogo-oracledb/1.0.1/doc/html/GUID-144B7222-EEF8-4E40-915B-09D5E4AC5D30.html
For the TIBCO Cloud environment, please refer to the below doc:
https://integration.cloud.tibco.com/docs/index.html#Subsystems/flogo-oracledb/users-guide/pushing-an-application-to-the-cloud.html?TocPath=TIBCO%2520Flogo%25C2%25AE%2520Connectors%257CTIBCO%2520Flogo%25C2%25AE%2520Connector%2520for%2520Oracle%2520Database%257C_____2

Sometimes, users still face the error after supplementing the Oracle client libraries. It could be due to the following reasons:

1 The Oracle client libraries must be Linux x86-64 (64-bit) - Basic Package(ZIP). Please make sure to download the correct package.

2 When extracting the Oracle client libraries, the symbolic links in the zip file are broken. Please refer to the below KB article for how to prepare the Oracle libraries for TIBCO Flogo Connector for Oracle Database
https://support.tibco.com/s/article/How-to-prepare-the-Oracle-libraries-for-TIBCO-Flogo-Connector-for-Oracle-Database

3 After extracting the Oracle client, the Oracle client libraries will be under the folder "oracle" or a folder like "instantclient_xx_x" (depends on different client versions). Please make sure to use the content of folder "oracle" or "instantclient_xx_x".

4 For the Flogo Enterprise environment, there are two lib folders under FLOGO_HOME:
        FLOGO_HOME/lib
        FLOGO_HOME/<version>/lib
   Please make sure to copy the Oracle client libraries to FLOGO_HOME/lib/oracledatabaselib

Additional Information

https://docs.tibco.com/pub/flogo-oracledb/1.0.1/doc/html/GUID-144B7222-EEF8-4E40-915B-09D5E4AC5D30.html

https://integration.cloud.tibco.com/docs/index.html#Subsystems/flogo-oracledb/users-guide/pushing-an-application-to-the-cloud.html?TocPath=TIBCO%2520Flogo%25C2%25AE%2520Connectors%257CTIBCO%2520Flogo%25C2%25AE%2520Connector%2520for%2520Oracle%2520Database%257C_____2

https://support.tibco.com/s/article/How-to-prepare-the-Oracle-libraries-for-TIBCO-Flogo-Connector-for-Oracle-Database