[Oracle]How to Unlock Expired Account
If you ever get this error in your dev then you should consider unlock your oracle account and set it to never expire.
ORA-28001: the password has expired
Login with your system account and run the following SQLs.
-- find out your profile name
SELECT profile FROM DBA_USERS WHERE username='<username>';
-- check password limit
SELECT resource_time, limit FROM DBA_PROFILES WHERE profile='<profile_name>';
-- reset password and unlock account
ALTER USER <username> IDENTIFIED BY <new_password> ACCOUNT UNLOCK;
-- disable expiration
ALTER PROFILE <profile_name> LIMIT password_life_time UNLIMITED;
-- disable password policy
ALTER PROFILE <profile_name> LIMIT password_verify_function NULL;
Then your account should be ready to use.