数据库用户别锁定了
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.