ORA-28040: No matching authentication protocol with Oracle 12.2
schebrolu
Posts: 1 New member
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
I saw another post where it was recommended to use ojdbc8.jar. I tried that with no luck.
Any help would be appreciated
Tagged:
Answers
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:
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
Have you visited our Help Center?