ORA-28000 : The Account is locked

So, I was installing SOA Suite 12c on my machine the other day and in the middle of running the RCU forgot my schema password(at least I thought so).

Desperately kept entering one password after another in the hopes of getting it right but the account got locked after some tries and kept throwing "ORA-28000: the account is locked" error message.

After some digging came up with a solution!
This can be used in any scenario where your account gets locked in an Oracle Database. You will just need an account with SYSDBA role.

You will just need to login as an admin user and run the following SQL query:



alter user DEV account unlock;
grant connect, resource to DEV;

Hope this helps someone else too!

Comments

Popular Posts