Unlock Oracle user account

Here's how to lock or unlock Oracle database user accounts.

ALTER USER username ACCOUNT LOCK;

ALTER USER username ACCOUNT UNLOCK;

you may also have to use:

GRANT connect, resource TO username;

to solve the "ORACLE ERROR:ORA-28000: the account is locked" error.