Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Error occurred loading library [libclntsh.so.11.1: cannot open shared object file" on running mappings from Informatica 10.2.1
Problem Description

While running mappings involving native connectivity to Oracle Database in Hadoop pushdown mode using Informatica 10.2.1 or later versions, execution fails with an error in loading Oracle drivers. However, the same mapping was working fine in Informatica versions before 10.2.1.

 

Log Trace

 

Error occurred loading library [libclntsh.so.10.1: cannot open shared object file: No such file or directory]Database driver event...Error occurred loading library [libpmora8.so]]

​ 

Cause

The issue occurs when the Oracle Client library path is not included in the 'Cluster Library Path' attribute of the Hadoop connection, used for running the mapping.

 

Starting from Informatica 10.2.1 version, 'hadoopEnv.properties' file would not be available in Informatica server machine. For ease of use, the configuration of all the Hadoop pushdown job settings have been moved to the 'Hadoop Pushdown connection'. As a result, all the settings can be configured directly, either from Informatica Developer client or from Informatica Administrator console. 

Solution

To resolve the issue, perform the following steps:

 

  1. Log into Informatica Administrator console or launch Informatica Developer client.
  2. Navigate to 'Connections' tab in case of Admin console and 'Windows > Preferences > Connections > [Domain]' , when Developer client is used.
  3. Select the 'Hadoop Pushdown' connection, being used for running the jobs.
  4. Navigate to 'Hadoop Cluster Properties' section.
  5. Edit the 'Cluster Library Path'  attribute in the section.
  6. In the 'Cluster Library Path'  attribute window, include the 'Oracle client library' location:

 

<oracle_client_home>/lib

 

E.g. If the Oracle client is installed at '/databases/client_12.2.0.1/' location, then update the 'Cluster Library Path' attribute to include '/databases/client_12.2.0.1/lib' location.

 

bdm_1021_add_lib_to_library_path_hadoop_connection.png


 

   7. Once done, save the changes made to the Hadoop connection.

   8. Re-run the mapping and it should complete successfully. 

Note


If the mapping is being executed in 'Blaze Engine' and if the 'Blaze Grid Manager Application' is already running in the Hadoop cluster, you need to restart the Blaze Engine for the changes to take effect. For more information on restarting Blaze Engine, refer to KB 521162.

More Information
Applies To
Product: Data Engineering Integration(Big Data Management); Enterprise Data Catalog; Enterprise Data Preparation; Data Engineering Quality(Big Data Quality); Data Engineering Streaming(Big Data Streaming)
Problem Type: Configuration; Connectivity
User Type: Administrator; Developer
Project Phase: Implement; Onboard
Product Version: Informatica 10.2.1; Informatica 10.2.1 Service Pack 1; Informatica 10.2.2; HotFix; Informatica 10.4
Database:
Operating System: Linux
Other Software:

Reference
Attachments
Last Modified Date:3/31/2020 4:16 AMID:535100
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)