Reason and method of Oracle user being locked

Reason and method of Oracle user being locked
Be told that the test user is locked when logging in
1, with the DBA role of the user login, unlock, first set the specific time format, in order to see the specific time
Sql> alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss ';
Session altered.
2, check the specific lock time
Sql> Select Username,lock_date from dba_users where username= ' TEST ';
USERNAME lock_date
------------------------------ -------------------
TEST 2009-03-10 08:51:03
3. Unlocking
sql> alter user test account unlock;
User altered.
4, check that the IP caused by the test user is locked

View $oracle_home/network/admin/log/listener.log Logs
10-mar-2009 08:51:03 * (Connect_data= (sid=lhoms) (server=dedicated) (Cid= (program=oracle) (HOST=OMSTESTDB) (USER= oraoms)) * (Address= (PROTOCOL=TCP) (host=10.69.1.11) (port=49434)) * Establish * lhoms * 0
10-mar-2009 08:51:03 * (Connect_data= (sid=lhoms) (server=dedicated) (Cid= (program=oracle) (HOST=OMSTESTDB) (USER= oraoms)) * (Address= (PROTOCOL=TCP) (host=10.69.1.11) (port=49435)) * Establish * lhoms * 0www.examda.com exam is a big test
This is known as the above 10.69.1.11 IP attempts to fail the landing caused by the lock
Note:
The general database defaults to 10 attempts to lock the user after a failure http://hovertree.com/menu/oracle/
1. View the value of the failed_login_attempts
SELECT * FROM Dba_profiles
2, modified to 30 times
Alter profile default limit failed_login_attempts 30;
3, modified to unlimited (for security purposes, not recommended)
Alter profile default limit Failed_login_attempts unlimited;

Recommendation: http://www.cnblogs.com/roucheng/p/3506033.html

Reason and method of Oracle user being locked