Oracle: Remove password Expiry

From 11g, Oracle introduced password life time,and it caused some issues as all of our applications stopped working, and we had to update the config file with new password. To disable this feature in Oracle,

1) Find the Profile attached to your user

select username,profile
from dba_users
where username ='SCOTT'
order by 2,1



2) Find the Password Expiry period for that profile

select *
from dba_profiles
where profile = 'DEFAULT'
and resource_name = 'PASSWORD_LIFE_TIME'



3) Change "PASSWORD_LIFE_TIME" to UNLIMITED

Alter Profile DEFAULT Limit PASSWORD_LIFE_TIME UNLIMITED;

4) Query the Profile again to check the new limit