Oracle10g Profile FAILED_LOGIN_ATTEMPTS
如果恢复之前无限制,可以通过一条命令解决:
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
数据库的profiles信息:
SQL> select * from dba_profiles;
PROFILERESOURCE_NAME RESOURCE LIMIT
---------------- -------------------------------- -------- ------------------------------
DEFAULTCOMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULTSESSIONS_PER_USER KERNEL UNLIMITED
DEFAULTCPU_PER_SESSION KERNEL UNLIMITED
DEFAULTCPU_PER_CALL KERNEL UNLIMITED
DEFAULTLOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULTLOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULTIDLE_TIME KERNEL UNLIMITED
DEFAULTCONNECT_TIME KERNEL UNLIMITED
DEFAULTPRIVATE_SGA KERNEL UNLIMITED
DEFAULTFAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULTPASSWORD_LIFE_TIME PASSWORD UNLIMITED
PROFILERESOURCE_NAME RESOURCE LIMIT
---------------- -------------------------------- -------- ------------------------------
DEFAULTPASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULTPASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULTPASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULTPASSWORD_LOCK_TIME PASSWORD UNLIMITED
DEFAULTPASSWORD_GRACE_TIME PASSWORD UNLIMITED
16 rows selected.