ORA-28000: the account is locked

Hi,

Sometimes You can get “ORA-28000: the account is locked ” error.

 

Details of error are as follows.

ORA-28000: the account is locked



Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile
 parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account

Action: Wait for PASSWORD_LOCK_TIME or contact DBA

 

 

To solve this error, unlock the related user as follows.

ALTER USER USER_NAME ACCOUNT UNLOCK;



SQL> ALTER USER MEHMET ACCOUNT UNLOCK;

 

Or increase the Password Life time parameter as follows.

 

Check the related profile limit.

SELECT resource_name, limit
FROM dba_profiles 
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';

 

Change default password life time to unlimited as follows.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/