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

alter user account unlock;