Skip to main content

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


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_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: 

Product Version Category
CAPTURE 10.2 Administration

Keywords: ORA-02019

  • Was this article helpful?