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