Fixing of TNS Lookup failures errors thrown by Oracle Bulk Load Snap

Fixing of TNS Lookup failures errors thrown by Oracle Bulk Load Snap

Oracle bulk load snap description : Snap executes an Oracle bulk load. The Snap uses Oracle SQLLoader internally to perform the bulk load action. The input data is first written to either a temporary data file (on a Windows JCC) or a named pipe (on a Linux JCC). Then the Oracle SQLLoader loads the data from the data file/named pipe into the target table.

Error : TNS Lookup failures.

Steps :
Update the application Oracle Account to reference the fully qualified service name as the value for the Database property.
Update the value of the Database specifier type to Service name.
Update the local SQLNET.ORA file on the Snaplex node to include EZCONNECT in the NAMES.DIRECTORY_PATH definition