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