Wednesday, October 6, 2010

Unlock account in Oracle Database (ORA-28000)

An oracle database account can get locked for several reasons. The most common reason is number of unsuccessful attempts. This typically give the following error :

ORA-28000: the account is locked

Account can be unlocked by logging in as 'sys' user and issuing the following command:

SQL> alter user scott identified by tiger account unlock;