ORA-28051: the account is locked

Mehmet Salih Deveci

5 years ago

Hi,

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

Details of error are as follows.

ORA-28051: the account is locked

Cause: The enterprise user has consecutively entered the wrong password for maximum number of times specified in the realm’s password policy profile.

Action: Contact the directory administrator.

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;