Jslfl【软件开发技术笔记】

oracle11g密码错误重试多次后,账号连接速度奇慢

oracle11g 密码错误重试多次后,该账号连接速度奇慢,解决:sqlplus dba下执行

alter system set events=’28401 trace name context forever, level 1′; —不需要重启

一般重试多了账号会锁定,先解锁吧:
ALTER USER username ACCOUNT UNLOCK;

更可以设置不限制重试次数
alter profile default limit failed_login_attempts unlimited;

Comments are currently closed.