How to Fix an Oracle User's Password When It Has Expired

Posted on September 8, 2016, 10:33 pm

---

In sqlplus connect as sysdba

SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';

ALTER USER {username} IDENTIFIED BY {password};

ALTER USER {username} ACCOUNT UNLOCK;

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';