ORA-28040使用SQL Plus客户端版本11.1从SQL PLUS连接到oracle 12c DB时没有匹配的身份验证协议 [英] ORA-28040 No Matching authentication protocol when connecting from SQL PLUS to oracle 12c DB using sql plus client version 11.1

问题描述

当我尝试从sqlplus连接oracle 12c远程数据库时，我得到了ORA-28040，同时使用SQL Developer(基本连接和TNS连接)连接到同一数据库时能够成功连接.我还注意到我能够从sql plus连接到本地网络上的sql plus 12c数据库，但是此问题仅与远程数据库服务器有关.

I am getting ORA-28040 when trying to connect oracle 12c remote database from sqlplus while able to connect successfully when connecting to same same database using SQL developer(both basic and TNS connection). Also I have noticed that I am able to connect to 12c database from sql plus which are on local network but this problem is only with regards to remote database server

我已经尝试了客户端sqlnet.ora文件中的以下设置

I have already tried below settings in client sqlnet.ora file

SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

但没有运气.

推荐答案

基本问题是您试图使用不受支持的客户端和服务器组合.由于12c正在使用新的密码加密算法，因此会引发实际错误.无法在客户端sqlnet.ora文件中设置SQLNET.ALLOWED_LOGON_VERSION_SERVER.该错误是由服务器端引起的.因此，需要相应更改服务器的sqlnet.ora文件.

The basic problem is that you are trying to use an unsupported combination of client and server. The actual error is raised as 12c is using a new password encryption algorithm. Setting SQLNET.ALLOWED_LOGON_VERSION_SERVER in the client sqlnet.ora file cannot work. The error is caused by the server side. Therefore the sqlnet.ora file of the server needs to be changed accordingly.

这篇关于ORA-28040使用SQL Plus客户端版本11.1从SQL PLUS连接到oracle 12c DB时没有匹配的身份验证协议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！