search cancel

ORA-28040: No matching authentication protocol

book

Article ID: 201471

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent CA Workload Automation AE

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

Cause

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

Environment

Release : 11.4.x

Component : CA Workload Control Center

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