Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Prashant.

Asked: September 10, 2018 - 8:00 pm UTC

Last updated: September 11, 2018 - 9:38 am UTC

Version: 12c

Viewed 10K+ times! This question is

You Asked

Hello All,



I am trying to connect to Database . I am getting error as below while trying connection to oracle DB:



Can't get the Connection for specified properties; java.sql.SQLException: ORA-28040: No matching authentication protocol



I kept ojdbc6.jar under lib directory and after looking at posts online, mentioned below in sqlnet.ora:



SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION=8



Still getting same error. anyone pelase help.



Thanks in advance

and Chris said...

Try setting SQLNET.ALLOWED_LOGON_VERSION_CLIENT to a value lower than 11 (10, 9, or 8).

Or using a newer version of the JDBC driver. You can get these at:

https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html

Also check you have no older versions of the JDBC driver (e.g. ojdbc14.jar) kicking around.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.