oracle unlock user account

SQL/PLUS unlock a user



1.  Select dba_users table, and find out which user account were locked.
SQL> select username,lock_date from dba_users;

USERNAME                       LOCK_DATE
------------------------------ ---------
SYS
SYSTEM
OUTLN
DBSNMP
OPS$PRDADM
SAPR3

2. Use below statement to unlock a user account.
alter user <username>

             alter user <username> account unlock;