ORA-02019 connection description for remote database not found when publishing Batch Class with Database Validation to Oracle 12c

Question / Problem:

I receive the following error message in the ODBC trace log file when publishing a Batch Class that has Database Validation to an Oracle 12c Database:

DIAG [HY000] [Oracle][ODBC][Ora]ORA-02019: connection description for remote database not found (2019).

How can I resolve this issue?

Answer / Solution:

This error can be caused by the Database trigger in Oracle that is changing the NLS parameters (NLS_COMP and NLS_SORT) of the Validation database.

Using an Oracle database user that doesn't allow those changes to be made to the Validation database in the Database Validation setting has been seen to fix the issue.

Applies to: 

Keywords: ORA-02019