Remove oracle users password expiration

# Reset password
ALTER MYUSER1 ACCOUNT UNLOCK;
ALTER MYUSER1 IDENTIFIED BY 'PASSWORD1';
# Check which profile is in use
SELECT profile from DBA_USERS where username = 'MYUSER1';
# See PROFILE settings
SELECT resource_name,limit from dba_profiles where profile='DEFAULT'
# Change the settings
ALTER profile DEFAULT limit password_life_time UNLIMITED;
ALTER profile DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS 1024;