java - Error connecting to 19c Database "No Matching protocol"

Question

We had upgraded from Oracle 11g to 19c recently and one of the Java program which connects to Oracle DB via OJDBC started throwing below error:

java.sql.SQLException: ORA-28040: No matching authentication protocol

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)

We have tried the below options :

1. Added the below lines in sqlnet.ora SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
2. Replaced ojdbc14.jar with ojdbc6.jar.
3. Other JARs that I tried are ojdbc7.jar , ojdbc8-full.jar.

None of the above seems to work. When I tried replacing with ojdbc8-full.jar, I get to see a different error:

java.sql.SQLException: No suitable driver found for DB_URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)...

Oracle Version: 19c
Java Version: 1.7

question from:https://stackoverflow.com/questions/65919816/error-connecting-to-19c-database-no-matching-protocol

Answer 1

Waitting for answers