Change Database User Password Expiry to Unlimited in Oracle 11gR2/10gR2

Step1: Check Database user profile

select username,expiry_date,created,profile from dba_users order by expiry_date desc

Step2: Check Password life time for above profile

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

DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

Step3: Set Password life time for the profile to unlimited

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;