When the following error occurs:
ORA-28002: the password will expire within 7 days
Two ALTER styatements are required in order for the user to stop receiving such errors when a connection is attempted:
Assume the two ALTER statement are executed as SYS:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER USER USERNAME IDENTIFIED BY PASSWORD;
