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

Question

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?

Answer 1

You can unlock the account by using the command prompt -

Step 1

Login to your account -

sqlplus "/ as sysdba"
OR
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;