ORA-28040 error when using [email protected]

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Problem executing action pack Automic JDBC ([email protected])

error message:

JDBC Driver JAR = D:\Apps\oracle\product\11.2.0\client_1\jdbc\lib\ojdbc6.jar"
"PARAM: JDBC Driver Class = oracle.jdbc.OracleDriver"

14:02:53 WARN  - Couldn't connect to database after 3 retries java.sql.SQLException: ORA-28040: No matching authentication protocol

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Use latest JDBC Driver.

https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html

https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15