Getting ORA-28040 during HDBSetup

Products

• CA Harvest Software Change Manager - OpenMake Meister

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

Release:
Component: CCCHV

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.