No matching authentication protocol error while connecting to Oracle 19c DB
search cancel

No matching authentication protocol error while connecting to Oracle 19c DB

book

Article ID: 250494

calendar_today

Updated On:

Products

CA Identity Manager

Issue/Introduction

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. 

        

Environment

Release : 14.3

Component :

Resolution

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.