使用plsql连接时,发现报ora-28040 no matching authentication protocol
赶紧查了查mos,原来在默认情况下oracle12.2对客户端版本有限制,
解决方法:升级oracle客户端或者修改sqlnet.ora中的以下两个参数控制:
sqlnet.allowed_logon_version_server=10
sqlnet.allowed_logon_version_client=10
select username, account_status, default_tablespace, created, password_versions from dba_users;
username account_status default_tablespace created password_versions
--------------- ---------------------------------------------------------------- ------------------------------------------------------------ ------------ ----------------------------------
sys open system 26-jan-17 10g 11g 12c
system open system 26-jan-17 10g 11g 12c
password_versions表明当前用户口令的认证方式.
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!