How to solve ORA-28000: the account is locked ?

+2 votes
asked Jan 27, 2016 by Hitesh Garg (799 points)  

I am running a tool and after running it for some time it just hangs up and when I try to access database after that, i start getting the error ORA-28000: the account is locked.

How to unlock the account and what could be the possible reason for the account getting locked?

1 Answer

0 votes
answered Jan 29, 2016 by Rahul Singh (682 points)  

You can unlock the account by using the command prompt -

Step 1

Login to your account -

sqlplus "/ as sysdba"
sqlplus $username/$password

Run any of the above two commands. If you run first command, then it might require your username and password. In second command replace $username and $password with actual credentials of database.

Step 2

After login execute the following command:

alter user $username account unlock;