数据库用户别锁定了
SQL> set linesize 2000
SQL> select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
从上面看出重试10次以后数据库被锁定
2)查看上次被锁定的时间
SQL> select LOCK_DATE,username from dba_users where username='JSCN';
LOCK_DATE为空说明没有锁定,非空为锁定。
LOCK_DATE, username
----------------- ------------------
2012/2/6 13:36:10 JSCN
3) 设置系统的默认登录次数
SQL> alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS 10; --连续重试10次锁定
Profile altered.
SQL> alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED; --不锁定
Profile altered.
4)解锁
SQL> alter user jscn account unlock;
User altered.