Check User is Locked
SELECT username,
account_status FROM dba_users;
List of Locked Users
SELECT
username,account_status,lock_date from dba_users where lock_date IS NOT NULL;
Unlock User
ALTER USER user_name
IDENTIFIED BY password ACCOUNT UNLOCK;
