Unlock database users

Unlock database users
1. log on to and unlock the account with the dba role. First, set the specific time format to view the specific time. SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. 2. Check the lock time (here you need to fill in the specific user name, the User Name of the following statement is TEST) SQL> select username, lock_date from dba_users where username = 'test'; USERNAME LOCK_DATE TEST 08:51:03 3. unlock SQL> alter user TEST account unlock; User altered. 4. view the test user lock caused by the ip address. 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 * (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 * 0 It can be seen that the above ip address is locked due to multiple failed login attempts: by default, the database locks users after 10 failed attempts. 1. Check the value of FAILED_LOGIN_ATTEMPTS. select * from dba_profiles. 2. Change it to alter profile default limit FAILED_LOGIN_ATTEMPTS 30; 3. Change it to an unlimited number of times (for security reasons, it is not recommended) alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited; The above content is the description of the reason and method for Oracle user lock, I hope it will help you in this regard.