Oracle 11 is expiring the passwords. How do I reset this?

Question

I recently migrated (six months ago) to Oracle 11 and now using the command sqlplus system@INTANCIA I started to receive the message below:

ORA-28002: the password will expire within 7 days

NOTE: I’m still able to log in and it just warns that the password will expire soon.

How do I configure my DBMS to not request password exchange. This is Developing and I have no security requirements at this level. I prefer not to introduce more complexity into Scripts by minors who are.

Answer 1

To verify which profile name is associated with a given set of users:

SELECT username, profile FROM dba_users 
WHERE username in ('SYSTEM', 'HR');

To check how a certain Profile is defined (relative to the PASSWORD_LIFE_TIME definition):

select resource_type, limit 
from dba_profiles 
where profile='DEFAULT' 
  and resource_name = 'PASSWORD_LIFE_TIME';

To change so that Oracle does not expire more passwords use:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;