IDM deployed against Websphere, attempting to connect to an Oracle 19c deployed on Exadata database, receiving the following connection error:
[9/2/22 16:27:13:331 GMT] 00000092 DataSourceCon E DSRA8040I: Failed to connect to the DataSource "". Encountered java.sql.SQLException: ORA-28040: No matching authentication protocol
DSRA0010E: SQL State = 99999, Error Code = 28,040
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
When testing the datasource directly within Websphere a similar message is output:
The test connection operation failed for data source iam_im Audit Data Source on server nodeagent at node wsidmcl-n01 with the following exception: java.sql.SQLException: ORA-28040: No matching authentication protocol DSRA0010E: SQL State = 99999, Error Code = 28,040.
Release : 14.3
Component :
The issue was related to the ojdbc drivers.
Removing the ojdbc6.jar Oracle driver from Websphere and replacing with Ojdbc8.jar resolved the error message.