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"}]
Was this topic helpful?
Document Information
Modified date:
23 September 2022
UID
ibm16823193