My Oracle Support Banner

Application Failed To Connect Using Ojdbc8.jar After Database Is Upgraded From 12c To 19c (Doc ID 2800816.1)

Last updated on NOVEMBER 01, 2022

Applies to:

JDBC - Version 19.7 and later
Information in this document applies to any platform.

Symptoms

After the database was upgraded from 12c to 19c, the application failed to connect to Oracle Database using ojdbc8.jar with ORA-28040: No matching authentication protocol. However the application was able to connect to Oracle Database using ojdbc6.jar successfully.

In sqlnet.ora file
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 11

Please help us understand why the application cannot connect using ojdbc8.jar
java -jar ojdbc8.jar -getversion
Oracle 19.7.0.0.0 JDBC 4.2 compiled with javac 1.8.0_241 on Tue_Feb_11_04:20:00_PST_2020

The connection works fine with ojdbc8.jar -> SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
But that's an issue - when the Oracle version for ojdbc8.jar is 19.7 then why should this be set?

 

Changes

 Upgrade from Oracle Database 12c to 19.7 and JDBC upgraded from 12.1.0.2 to 19.7 as well.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.