0%

Oracle 12c远程连接报ORA28040和ORA01017错误

ORA-28040: 没有匹配的验证协议
修改$ORACLE_HOME\NETWORK\ADMIN\sqlnet.ora文件,添加以下两行

1
2
SQLNET.ALLOWED_LOGON_VERSION_SERVER=9
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=9

ORA-01017的错误的解决方法:
sqlplus / as sysdba

1
ALTER USER username IDENTIFIED BY password

参考链接:
http://blog.itpub.net/28612416/viewspace-2138896/
https://m.aliyun.com/yunqi/articles/415260