So you have built out your dev/test/prod enviorments and have worked threw the process of getting all your customers migrated and life is finally looking up after all the misery you went threw. You are so confident now you are ready to actual take your system down and apply security patches! But after doing all your work OID won't come up and when you look @
ORA-28002: the password will expire within n days
where n is the number of days.
WTF you say? Rest assured my friend you have hit a new "feature" built into 11 R2 and it has just brought a moment of panic to your planned weekend outage. By default Oracle puts ODS & ODSSM on a 180 day self-destruct timer once you actually install the software. To avoid hitting this issue you can modify the default profile like so:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
or you can create a new profile and assign it to ODS & ODSSM. For further clarification you can take a look at note 1064334.1