Oracle默认允许用户输入10次错误密码,超过10次后账户就会被锁定
sys@ORCL>select * from dba_profiles where profile='DEFAULT' and resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
--------------- ------------------------------ ------------------------ -------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
测试zx用户,使用错误的密码连接11次
[oracle@rhel6 ~]$ cat login.sh
sqlplus zx/123