Using the LKM File to Oracle SQLLDR Module in a Mapping to Perform Load from a CSV File in ODI 12c Results in ‘SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]’ and ‘ORA-12154: TNS:could not resolve the connect identifier specified’ Errors (Doc ID 2105404.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

While using the LKM File to Oracle SQLLDR module in a mapping to perform load from a csv file, the following errors are encountered:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms