Thursday, November 14, 2019

ORA-28000: the account is locked - FIX


## unlock oracle user account of my_user
>Login as SYSTEM 
SQL>ALTER USER my_username IDENTIFIED BY my_new_password ACCOUNT UNLOCK;

##check password lifetime
SQL>SELECT resource_name, limit FROM dba_profiles WHERE profile = 'DEFAULT' AND resource_type = 'PASSWORD';
##Change default limit to unlimited in ORACLE
SQL>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Share Article : ORA-28000: the account is locked - FIX
Share/Save/Bookmark