Getting ORA-28040 during HDBSetup

Document ID : KB000006991
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When running the "CR" option in HDBSetup, getting error message: 28040 [CA Harvest SCM][ODBC 20101 driver]ORA-28040: No matching authentication protocol

Cause:

Seems to be 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: https://community.oracle.com/thread/2349728

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 to connect to Oracle server.  After restarting the Oracle server the error message did not appear again.