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.

Posted

in

,

by

Tags:


Related Posts

Comments

9 responses to “Resolve error – ORA-28000: the account is locked”

  1. belal Avatar
    belal

    thanks

  2. nithin Avatar
    nithin

    thank you so much. it worked

  3. Hiếu Hồ Trọng Avatar

    thank you , it worked.

  4. zoulfa Avatar
    zoulfa

    my count system has this problem ?? é

  5. Bayrem KADDOUSSI Avatar
    Bayrem KADDOUSSI

    And what’s the reason of this behavior please ?

  6. bala Avatar
    bala

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

  7. Ashutosh Jha Avatar
    Ashutosh Jha

    so what is my password now???please help sir please

    1. Hello World Avatar
      Hello World

      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.

  8. Hr Avatar
    Hr

    It is not working please help

Leave a Reply

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

Discover more from Jitendra Zaa

Subscribe now to keep reading and get access to the full archive.

Continue Reading