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 8 Comments 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.

Related posts

8 thoughts on “Resolve error – ORA-28000: the account is locked”

  1. am just installing the MySql , and my account is locked
    how can i resolve this and how can i launch successfully

    1. The password will remain the same. Just change the password using `ALTER USER USERNAME IDENTIFIED BY NEWPASS` where USERNAME is the name of your existing account and NEWPASS is your new password. Do this once you have connected to SQLPLUS as sysdba.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.