连接oracle 12c数据库报错ORA-28040: No matching authentication protocol

最新推荐文章于 2022-12-26 15:45:27 发布

Hydra.

最新推荐文章于 2022-12-26 15:45:27 发布

阅读量1.2k

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/qq_40657585/article/details/108219885

版权

当使用9i客户端尝试连接到Oracle 12c数据库时，会遇到ORA-28040错误。解决方法是在Oracle用户的$ORACLE_HOME/network/admin/sqlnet.ora文件中，取消SQLNET.ALLOWED_LOGON_VERSION=8的注释或创建该文件，并设置为允许更高版本的登录。

摘要由CSDN通过智能技术生成

使用9i的客户端去连接12c的数据库就会报ORA-28040: No matching authentication protocol这个错误。

解决过程

使用oerr命令来查看

[oracle@localhost admin]$ 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 t