To unlock an account:

alter user {USERNAME} account unlock;