ORA-28040:No matching authentication protocol on Oracle 12.2
Posted: Fri Mar 16, 2018 2:28 pm
We are using DRS plugin in our DataStage 11.3.1 jobs to connect to Oracle databases with odbc DSNs. These jobs are working fine with Oracle 12.1 version.
But when we upgrade to Oracle 12.2 version these jobs are aborting with "ORA-28040: No matching authentication protocol" error.
As per the progress link (https://www.progress.com/odbc/release-h ... abase-odbc), I Even tried installing the most recent version (07.16.0325 (B0373, U0246))of DataDirect ODBC drivers which was certified with Oracle 12.2.
But even then I am getting the same error. Did anyone face the same issue Could any one help me in fixing this.
I know one option of changing the settings on Oracle DB server side to allow the SQL Authentication for lower versions which I don't want to go as it will have security risks associated with it.
But when we upgrade to Oracle 12.2 version these jobs are aborting with "ORA-28040: No matching authentication protocol" error.
As per the progress link (https://www.progress.com/odbc/release-h ... abase-odbc), I Even tried installing the most recent version (07.16.0325 (B0373, U0246))of DataDirect ODBC drivers which was certified with Oracle 12.2.
But even then I am getting the same error. Did anyone face the same issue Could any one help me in fixing this.
I know one option of changing the settings on Oracle DB server side to allow the SQL Authentication for lower versions which I don't want to go as it will have security risks associated with it.