IBM Support

Resolving [Oracle]ORA-28040: "No matching authentication protocol" errors when connecting to MDM 12.0 from an Oracle 19 client

Question & Answer


Question

Why am I getting [Oracle]ORA-28040: No matching authentication protocol when connecting to MDM from my Oracle 19 client?


We have the below Oracle client versions.  If we are using 19.11.1.0.0 we are not receiving any authentication protocol error.  However, for the other Oracle client versions, we are getting "No matching authentication protocol" error.

Oracle Client Version :

  • 19.11.1.0.0
  • 19.13.0.0.0
  • 19.14.0.0.0
  • 19.15.0.0.0(32 bit)

Cause

MDM 12.0 supports Oracle Database 19c- (19.3) and future fix packs so the clients should be able to connect to MDM 12.0. 
It is not the actual Oracle client version that is causing the error, it is a configuration setting in the sqlnet.ora file.

Answer

Modify the sqlnet.ora file and set SQLNET.ALLOWED_LOGON_VERSION_SERVER=11 at the network level then try the connection again.

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"ARM Category":[{"code":"a8m0z000000cvpMAAQ","label":"Database, JDBC, ODBC"}],"ARM Case Number":"TS010564018","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.6.0;12.0.0"}]

Document Information

Modified date:
23 September 2022

UID

ibm16823193

Page Feedback