Problem Description: Oracle source ingestion job fails with the below error in the job log in Infoworks on Databricks.

Caused by: org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 6.0 failed 4 times, most recent failure: Lost task 0.3 in stage 6.0 (TID 108,, executor 0): java.sql.SQLException: ORA-28040: No matching authentication protocol

    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(
    at oracle.jdbc.driver.T4CConnection.logon(
    at oracle.jdbc.driver.PhysicalConnection.<init>(
    at oracle.jdbc.driver.T4CConnection.<init>(
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(
    at oracle.jdbc.driver.OracleDriver.connect(

Root cause: This issue happens because of a limitation (Bug 14575666) from the Oracle Database server end. In v12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. 

This means that database clients using pre-11g JDBC thin drivers (Infoworks users ojdbc6.jar)  cannot authenticate to 12.1 database servers unless the SQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8.

Solution: Check with your ORACLE DBA and Set SQLNET.ALLOWED_LOGON_VERSION=8 in the 

oracle/network/admin/sqlnet.ora file on the DB server-side and then try the ingestion job again.

Related Article

Applicable Infoworks on Databricks versions: