Unlock the Account in Oracle

A user account can be locked by an expiration of a password and can be unlocked with a command.

Steps

Find which accounts are locked with the following query.
- SQL > select username,account_status from dba_users where account_status like '%LOCK%';
- USERNAME ACCOUNT_STATUS
- ------------------------------ ----------------
- OUTLN EXPIRED & LOCKED
- MDSYS EXPIRED & LOCKED
- MDDATA EXPIRED & LOCKED
Unlock the user with the following command.
- SQL > alter user MDDATA account unlock; User altered.

You can also lock an account with the following:
- SQL > alter user MDDATA account lock;
- User altered.