Expired (Grace) Oracle Account

Wednesday, May 18, 2011

A user indicated he was getting the error below, but could still connect.

ORA-28002: the password will expire within 7 days

In Oracle 11g, the default expiration date for the “DEFAULT” profile has changed from UNLIMITED to 180 days.  Changed the setting with the SQL below.


Note:  This change only affects accounts who have not entered their grace period.  Accounts that have entered their grace period will have to change their passwords.

Must make a note in my database creation scripts to adjust this setting to UNLIMITED.  Not saying this is a good decision for a production database, but for my development and lab databases this will eliminate the problem with an expiring account.