Unlocking an Oracle 10g user account

So how do you unlock an Oracle user account?

1. Login as the oracle dba user (this is the account that is in the dba group)

2. Connect to the database as a DBA.

$ sqlplus / as sysdba

3. It's a straightforward command to unlock.

SQL> ALTER USER username ACCOUNT UNLOCK;

And that's it.