用户的profile有关,通常是default的,而default的profile默认的
FAILED_LOGIN_ATTEMPTS值是10,也就是说尝试10次就会锁定该帐号。
> select * from dba_profiles where resource_name=' FAILED_LOGIN_ATTEMPTS';
> select * from dba_profiles where resource_name=' FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
------------------------------ ------------------------------ ---------------- ------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
SQL> ALTER PROFILE default LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Profile altered.
或者根据监听日志判断谁在尝试口令。