When you log on using an Oracle database, you are told that the user is locked out _oracle

Was told that test user was locked on login

1, with the DBA role of the user login, to unlock, set the specific time format in order to view the specific time

Sql> alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss ';
Session altered.

　2, to see the specific time locked

Sql> Select Username,lock_date from dba_users where username= ' TEST ';
USERNAME lock_date
-------------------------------------------------
TEST 2009-03-10 08:51:03

　3, Unlock

sql> alter user test account unlock;
User altered.

4, view is that IP caused by the test user is locked

View $oracle_home/network/admin/log/listener.log Log

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 * (CO Nnect_data= (sid=lhoms) (server=dedicated) (Cid= (program=oracle) (HOST=OMSTESTDB) (user=oraoms)) * (ADDRESS= ( PROTOCOL=TCP) (host=10.69.1.11) (port=49435)) * Establish * lhoms * 0

This is known as the above 10.69.1.11 IP attempt multiple failed login caused by the lock

　　Note:

The normal database defaults to locking the user after 10 unsuccessful attempts

1, view the value of failed_login_attempts

SELECT * FROM Dba_profiles

2, modified to 30 times

Alter profile default limit failed_login_attempts 30;

3. Change to unlimited times (for security reasons, not recommended)

Alter profile default limit Failed_login_attempts unlimited;

The above is a small set to introduce the use of Oracle database login was told the user was locked how to solve, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!