ORA-28040 during HDBSetup

Products

• CA Harvest Software Change Manager - OpenMake Meister
• CA Harvest Software Change Manager

Issue/Introduction

When running the "CR" option in HDBSetup, getting error message:

28040 [CA Harvest SCM][ODBC 20101 driver]ORA-28040: No matching authentication protocol

Environment

Harvest Software Change Manager v12.x and higher

Cause

This is related to having differing versions of Oracle database and/or Oracle Client and/or ODBC software.

Here’s a link from the Oracle community that gives us a hint: ORA-28040: No matching authentication protocol in version 11.2.0.3

Resolution

DBA updated the sqlnet.ora file on the Oracle server machine and added the following line:

SQLNET.ALLOWED_LOGON_VERSION=8

This should allow older versions of the Oracle ODBC driver or client to connect to Oracle server.  After restarting the Oracle server the error message did not appear again.

Additional Information

It is always recommended and preferred to match your Oracle Client software version with the version of Oracle Server software you are using.

This article contains a matrix showing which versions of Oracle Client are compatible with which versions of Oracle Server: Client / Server Interoperability Support Matrix for Different Oracle Versions