Javelin - Oracle DataReader returns ORA-12154: TNS:could not resolve the connect identifier specified

Document ID : KB000113172
Last Modified Date : 05/09/2018
Show Technical Document Details
Issue:
When using an Oracle DataReader action (for example via a SubSet Bulk Copy), Javelin may throw an error/exception:
ORA-12154: TNS:could not resolve the connect identifier specified


Resolution:
Javelin connects to Oracle via the "Easy Connect" method via the ODP.NET driver. This requires ezconnect or hostname to be specified in the NAMES.DIRECTORY_PATH parameter within sqlnet.ora file.
Additional Information:
See Oracle's documentation for additional details on the ORA-12154 error.