Application Failed To Connect Using Ojdbc8.jar After Database Is Upgraded From 12c To 19c
(Doc ID 2800816.1)
Last updated on JUNE 03, 2024
Applies to:
JDBC - Version 19.7 and laterInformation 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 |