ORA-28040: No matching authentication protocol

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

WCC is not accessible. Seeing the below error message in the CA-wcc.log:

INFO   | jvm 1    | 2020/10/13 09:28:20 | Caused by: com.ca.wcc.jdbc.oraclebase.ddd1: [CA][Oracle JDBC Driver][Oracle]ORA-28040: No matching authentication protocol

Environment

Release : 11.4.x

Component : CA Workload Control Center

Cause

The authentication does not match between the Oracle database server machine and the WCC machine that has the Oracle Client installed on it.

Resolution

Need to put the following entry in the sqlnet.ora file on the database server:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=<version of the Oracle Client that is used on the WCC machine>

Example:

If running Oracle Client 8 on the WCC machine:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Need to put the following entry in the sqlnet.ora file for the database client that is running on the WCC machine:

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=<version of the Oracle Client that is used on the WCC machine>

Example:

If running Oracle Client 8 on the WCC machine:

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8