Sunday, February 28, 2016

How to unlock oracle database user account | ORA-28000: the account is locked

   Some times we may encounter with below error while we are trying to login to oracle database account.

We can unlock the account by using alter command, before that first we check the account status of DB users is as follows.

Step-1 : Login as sys/sysdba user

SQL> connect / as sysdba

Step-2 : Execute the below command to know the account status of database users.

SQL> select username, account_status from dba_users;

Step-3 : Execute the below command to unlock the database user account.

SQL> Alter user <User_Name> account unlock; //Here <User_Name> -Name of the oracle user
Account is unlocked and now you can able to login to account. Hope this helps.

No comments:

Post a Comment

back to top