How To Solve ORA-28040 On Navicat

Post author: David Chen
Post link: <a href="https://davidchenblog.com/posts/d3aa25a1/" title="How To Solve ORA-28040 On Navicat">https://davidchenblog.com/posts/d3aa25a1/
Copyright Notice: All articles in this blog are licensed under <span class="exturl" data-url="aHR0cHM6Ly9jcmVhdGl2ZWNvbW1vbnMub3JnL2xpY2Vuc2VzL2J5LW5jLW5kLzQuMC9kZWVkLnpo"> BY-NC-ND unless stating additionally.

Posted on 2023-11-10 Edited on 2024-07-03 In Oracle Views: Disqus: Symbols count in article: 311 Reading time ≈ 1 mins.

在一次移機中使用Navicat，發生ORA-28040: No matching authentication protocol錯誤

使用Navicat顯示ORA-28040: No matching authentication protocol錯誤。

原因是目前使用的Oracle為19c版本，但Navicat Client的oci.dll的版本使用到非19c版本。

解決方法先安裝instantclient_19_17 版本
再將版本改從指定為下
C:\Program Files (x86)\PremiumSoft\Navicat Lite\instantclient_19_17\oci.dl