Getting the following error: ORA-28002: the password will expire within x days O...

smallwei 11:28 am on October 16, 2009 | Answers: 1    
Tags: error (67), java (38), java sql, ora-28002, password (19), sql (43), sqlwarning

Rate Knowledge:

 Loading ...

• smallwei 11:28 am on October 16, 2009
  

  This is affected by a setting in the Oracle database that controls the users profile. If you do not want this behavior your DBA will need to do the following:

  1. Logon to the database as SYSTEM or SYS user (not the application administration user).
  2. Use the following sql to find the profile that has the PASSWORD_LIFE_TIME set to anything but UNLIMITED
  SELECT * FROM dba_profiles WHERE resource_name LIKE 'PASSWORD_LIFE_TIME';
  3. Alter the profiles with the following sql statement:
  ALTER PROFILE profile_name LIMIT PASSWORD_LIFE_TIME UNLIMITED;
  Note: profile_name is the name of the profile where your need to set the password life to UNLIMITED.
  4.You might need to reconnect your application to the database.

  This should remove the password life message.