Tuesday, March 6, 2012

Unlock an account

From your command prompt, type
SQLPlus "/ as SYSDBA"

SQL> ALTER USER scott ACCOUNT UNLOCK;
Make sure to execute the following command
SQL> COMMIT;

Oracle Query