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

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