SYMPTOM
In Strategy Secure Enterprise 9.4.x - 10.x, the following error is observed when attempting to connect to an Oracle 12cR2 database using the Strategy ODBC Oracle Wire Protocol driver:
[Strategy][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol
CAUSEThe version of the Oracle Wire Protocol driver shipped with Strategy 9.4.x - 10.9 (version 7.x and below) does not work with the default authentication protocol defined for Oracle 12cR2 (which is version 12).
ACTIONStarting from Strategy 10.4 HF6/10.10, the Strategy oracle wire protocol driver is 8.01, which support SQLNET.ALLOWED_LOGON_VERSION_SERVER=12. Upgrade to these version to take advantage of this fix.
For Strategy version 10.4 HF5/10.9 and below, within the SQL configuration file on the Oracle database server, usually the SQLNET.ORA file, the following changes will need to be made: SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameters need to be changed from 12 to 11.
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 11
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 11
Restart the database service after making the change, this will allow a connection to be authenticated using earlier Oracle authentication protocols.
Note:Referenced Data Direct KB article:
https://knowledgebase.progress.com/articles/Article/Connect-Connect64-for-ODBC-Oracle-12cR2-supportThis issue has been logged as Scopus ID: 211822 and KB ID: 38786 KB438786