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.