Application Failed To Connect Using Ojdbc8.jar After Database Is Upgraded From 12c To 19c
(Doc ID 2800816.1)
Last updated on AUGUST 26, 2021
Applies to:JDBC - Version 19.7 and later
Information in this document applies to any platform.
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 22.214.171.124.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?
Upgrade from Oracle Database 12c to 19.7 and JDBC upgraded from 126.96.36.199 to 19.7 as well.
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