DB user account expired

Today we faced and issue where one of the db user was expired. Please find the below steps to fix this Step 1: Login to db as sys user sys as sysdba pwd Step 2: Run the command to see the status of the user select username,account_status, expiry_date from dba_users where username like '%CRP2_ODI%' ; USERNAME ACCOUNT_STATUS EXPIRY_DA ------------------------------ -------------------------------- --------- CRP2_ODI EXPIRED 06-AUG-15 Step 3: Find out the actual old encrypted password of the user select password from sys.user$ where name='CRP2_ODI'; PASSWORD ------------------------------ 6501D0D1F3AC2 //I have modified the above password for security reason. Step4 : Use that password and reset the acocount. alter user CRP2_ODI identified by values '65D0D1F3AC2'; ////I have modified the above password for security reason. Step 5: select username,account_status, expiry_date from dba_users where username like '%CRP2_ODI%' ; USERNAME ACCOUNT_STATUS EXPIRY_DA ------------------------------ -------------------------------- --------- CRP2_ODI OPEN 02-FEB-16