IBM Support

Unable to do view data using Datastage oracle connector

Troubleshooting


Problem

The following error occurs for "view data" and "test connection" actions in Oracle Connector stage properties, even though the job itself runs succesfully: An Exception occured while trying to receive the response form the handler: An exception was received from the handler: Error loading connector library libccora10g.so. libcIntsh.so.10.1: cannot open shared object filr: No such file or directory

Cause

Node agents were not started after adding the oracle environment variables to the dsenv file

Diagnosing The Problem

If the jobs are unable to run, please refer to the Oracle connectivity guide and verify if all the Installation and configuration requirements are met. Also any changes to dsenv file will require the node agents to be restarted.

Resolving The Problem

Restart node agents

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5;8.1;8.0","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21441132

Page Feedback