解决方法:
在sqlnet.ora中新增配置
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11
sqlplus / as sysdba 登录,修改相应用户密码;以scott为例:
alter user scott identified by scott;
查看 PASSWORD_VERSIONS,多了一个 10G
select username, account_status,password_versions from dba_users where account_status='OPEN' and username = 'SCOTT';
USERNAME ACCOUNT_STATUS PASSWORD_VERSIONS
-------------------- -------------------------------- -----------------
SCOTT OPEN 10G 11G 12C
重启服务和监听,重新连接
小结:
oracle11g 客户端连接 oracle 12c服务器,需要在服务器端配置 sqlnet.ora,并重新修改用户密码;