ORA-28040: No matching authentication protocol with Oracle 12.2

I am invoking sco CLI command to connect to Oracle 12.2. It fails with ORA-28040: No matching authentication protocol error. It works fine with 12.1 release.

I saw another post where it was recommended to use ojdbc8.jar. I tried that with no luck.

Any help would be appreciated

Shyam Chebrolu February 07, 2019 15:34

Comments

1 comment

Hi @...,

There are several things related to this error, related to swapping out jar files (for example this Stack Overflow article) that may help - though you mention that this didn't seem to work (the jar files you an d the article mention vary, so maybe trying a different one would help).

Also, in some cases it's related to the advice in the below articles:
https://developer.ibm.com/answers/questions/177075/after-upgrading-to-oracle-12c-database-i-start-get/
http://www.redstk.com/ora-28040-no-matching-authentication-protocol-after-upgrade-to-12c/

Which essentially state that your oracle/network/admin/sqlnet.ora file needs to have:
```
Set SQLNET.ALLOWED_LOGON_VERSION=8
```
Ultimately though, the error is that the JDBC driver cannot connect to the instance and you need to have a version of the JDBC driver that is allowed to connect to your instance based on the allowed_logon_version mentioned above.

I hope that helps!

Kind regards,
Alex
Alex B February 11, 2019 10:34

0

Add comment

Please sign in to leave a comment.

How can we help you today?

ORA-28040: No matching authentication protocol with Oracle 12.2

Comments

Add comment