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.
665 views last month, 2 views today