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;
