低版本客户端连接高版本数据库报错ORA-01017

刘泽宇

在服务器端添加了允许登录的客户端版本
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
但是客户端登录依旧报错ORA-01017: invalid username/password; logon denied
能够确认输入的密码没问题的，使用高版本的客户端，同样的密码测试连接也正常连接

根据MOS 文档 2040705.1：
Lockout of all database authenticated users getting error ORA-01017: invalid username/password; logon denied (Doc ID 2040705.1）

查询用户的PASSWORD_VERSIONS：

SQL> select username, password_versions from dba_users where password_versions is not null;

USERNAME                       PASSWORD_VERSIONS
------------------------------ -----------------
SYS                               11G 12C
SYSTEM                       11G 12C
TEST                               11G 12C

With this solution you will also need to change the user password again so the DBA_USERS.PASSWORD_VERSIONS will get a 10G value, however the DES based verifiers are outdated and should only be used in exceptional cases when legacy client applications still need it.
需要再次修改密码
alter user TEST identified by oracle;
SQL> select username, password_versions from dba_users where password_versions is not null;

USERNAME                       PASSWORD_VERSIONS
------------------------------ -----------------
SYS                               11G 12C
SYSTEM                       11G 12C
TEST                               10G 11G 12C

再次尝试连接，能够使用低版本客户端连接了