Resolve error – ORA-28000: the account is locked

Author posted by Jitendra on Posted on under category Categories Oracle, SQL and tagged as Tags , with 1 Comment on Resolve error – ORA-28000: the account is locked

How to Resolve error – ORA-28000: the account is locked

It is the chance that you might come across the error “ORA-28000: the account is locked“. To unlock the account, run below sql query in Oracle using admin user.

Lets say that you want to unlock account “om” in oracle

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

I hope it would be helpful for the readers.