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

+2 votes
1,819 views
asked Jan 28, 2016 by Hitesh Garg (167 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 30, 2016 by Rahul Singh (253 points)  

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;

36 questions

24 answers

3 comments

17 users

Welcome to Codingeek Q&A, where you can ask questions and receive answers from other members of the community.
...