QAID # 21654 Published
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_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.