How to Solve Ora-28000: The Account Is Locked Error?

1. Introduction

In this article, we will discuss about the root cause and solutions for the error Ora-28000: The Account is locked in oracle.

2. ORA-28000 Cause

The error normally occurs when the database user account is locked either locked after the multiple wrong password attempts or the DBA manually locks the account for any reason.

Also the user account will be locked if you try to login multiple times when the password is expired.

3. ORA-28000 Solution

The user account must be unlocked by DBA by using the following query.

ALTER USER USER_NAME ACCOUNT UNLOCK;

As a preventive option, we can increase the number of FAILED_LOGIN_ATTEMPTS parameter set in the Oracle database.

This would increase number of failed login attempt before password is locked. On the other hand, the security of the database is compromised with the increased number of Failed Login attempts.

4. Conclusion

Finally, we have discussed the root cause for the error ORA-28000: the account is unlocked error and the different ways to solve the error. Feel free to comment if you have any questions.

How to unlock Oracle user account?

ALTER USER USER_NAME ACCOUNT UNLOCK;

What are the privileges required to unlock the user account in Oracle?

DBA privileges are required to unlock a user account in Oracle.

How to change password lifetime in Oracle?

you can set the password_life_time using the query:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME 10;

How to check password lifetime in Oracle?

Password life time depends on the profile assigned to each user. Check the password life time of the profile assigned to the user using the query.
SELECT resource_name, limit FROM dba_profiles WHERE profile = 'DEFAULT' AND resource_type = 'PASSWORD';

How to set Password lifetime to unlimited in Oracle?

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;