ORA-28051: the account is locked

Hi,

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

Details of error are as follows.

ORA-28051: the account is locked

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/