Oracle - Dealing with locked accounts and password expiration

ora-password-expiration.sql

-- Identify and change profile life_time
select profile from DBA_USERS where username = '<username>';
alter profile <profile_name> limit password_life_time UNLIMITED;
select resource_name,limit from dba_profiles where profile='<profile_name>';

-- Identify which accounts are about to expire (or expired), change password and unlock
select username,expiry_date,account_status from dba_users ORDER BY expiry_date DESC;
alter user <username> identified by <new_password> account unlock;