ORA-28040: No matching authentication protocol

最新推荐文章于 2021-05-25 11:24:43 发布

朝闻道-夕死可矣

最新推荐文章于 2021-05-25 11:24:43 发布

阅读量684

点赞数 1

分类专栏： -- ORA

本文链接：https://blog.csdn.net/jc_benben/article/details/78407692

版权

-- ORA 专栏收录该内容

37 篇文章 1 订阅

订阅专栏

[oracle@centos7 ~]$ oerr ora 28040
28040, 0000, "No matching authentication protocol"
// *Cause:  There was no acceptable authentication protocol for 
//          either client or server.
// *Action: The administrator should set the values of the
//          SQLNET.ALLOWED_LOGON_VERSION_SERVER and 
//          SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameters, on both the
//          client and on the server, to values that match the minimum 
//          version software supported in the system. 
//          This error is also raised when the client is authenticating to 
//          a user account which was created without a verifier suitable for
//          the client software version. In this situation, that account's 
//          password must be reset, in order for the required verifier to
//          be generated and allow authentication to proceed successfully.

提示没有匹配的协议，

方法：在Oracle的安装路径下找到sqlnet.ora文件，没有就添加一行SQLNET.ALLOWED_LOGON_VERSION=8