How to determine and UNLOCK oracle database users.

How to determine and UNLOCK oracle database users

Login as SYSDBA

SQL> conn /as sysdba

Check the TESTUSER account status.

SQL> SELECT username, account_status FROM dba_users WHERE username= ‘TESTUSER’;

USERNAME        ACCOUNT_STATUS        PROFILE
--------------         -------------------------     ----------------
TESTUSER            LOCKED(TIMED)           DEFAULT

Here we can see the account status is LOCKED (TIMED) and the default user’s profile is DEFAULT.

Unlock the user account:
SQL> ALTER USER TESTUSER ACCOUNT UNLOCK;
User altered.

Now check again the status of TESTUSER user.
SQL> SELECT username, account_status FROM dba_users WHERE username= ‘TESTUSER’;