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;
Do you want to learn Oracle Database for Beginners, then read the following articles.
1,859 views last month, 1 views today