How to Unlock the Account in Oracle
1. Find which accounts are locked with the following query. run oracle using command prompt. SQL > select username,account_status from dba_users where account_status like '%LOCK% '; USERNAME ACCOUNT_STATUS ------------------------------ ---------------- OUTLN EXPIRED & LOCKED MDSYS EXPIRED & LOCKED MDDATA EXPIRED & LOCKED 2.Unlock the user with the following command. SQL > alter user MDDATA account unlock; User altered.