Buy @ Amazon

Search This Blog

August 25, 2010

ORA-28000: the account is locked

Problem: ORA-28000: the account is locked
Cause: This happens for reasons galore. Some of them being as follows:
  • if bad password is provided more than the permissible number of times, then the account gets locked
  • the DBA has locked the specific account for some reason
Solution: You can request the administrator to unlock the account :P He would fire a query something like the one below:
SQL> alter user scott identified by tiger account unlock;

For more explanation on this read Oracle DBA Tips or even better take deep dive by buying the coolest book Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)