How to unlock a user account in Oracle

Unlock an account that locked after failed logins or a lock action.

This statement changes account state. Review it and run it deliberately.

ALTER USER &&username ACCOUNT UNLOCK;

-- Verify (read-only)
SELECT username, account_status, lock_date
FROM   dba_users
WHERE  username = UPPER('&username');