ORA-28040: No matching authentication protocol

windows客户端 Navicat、PLSQL Developer等连接 Linux服务器端的12C 报错如下:
ORA-28040: No matching authentication protocol
 
解决办法:
sqlnet.ora 文件中添加如下参数,不用重启监听。
 
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
 
 
如果登录后再报错:
ORA-01017: invalid username/password; logon denied
 
则修改密码即可。
 
参考文档:
12c Database Alert.log File Shows The Message: Using Deprecated SQLNET.ALLOWED_LOGON_VERSION Parameter (文档 ID 2111876.1)
Error "ORA-28040: No matching authentication protocol" When Using SQLNET.ALLOWED_LOGON_VERSION (文档 ID 755605.1)
 
 
 
原文地址:https://www.cnblogs.com/l10n/p/9143213.html