ORA-28011 Password Expiry Date is Reached But Reset to NULL (Doc ID 1079860.6)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.5.0 to 11.2.0.3 [Release 8.0.5 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 22-Sep-2012


Symptoms

You try to age passwords through a profile and set PASSWORD_LIFE_TIME 1/2880. The following warning message is reported:


ORA-28011: the account will expire soon; change your password now



SQL> create profile worker limit password_life_time 1/2880;
Profile created.

SQL> create user jeff identified by jeff profile worker;
User created.

SQL> alter user jeff profile worker;
User altered.

SQL> select username, expiry_date from dba_users where username='JEFF';

USERNAME                       EXPIRY_DA
------------------------------ ---------
JEFF                           29-NOV-01

SQL> grant connect,resource to jeff;
Grant succeeded.

SQL> connect jeff/jeff
Connected.


When you log in as jeff/jeff after 30 seconds, when the password expires, the error ORA-28011 is reported, but the expiry date is set to NULL.

SQL> connect jeff/jeff
ERROR:
ORA-28011: the account will expire soon; change your password now
Connected.

SQL> select username, expiry_date from dba_users;

USERNAME                          EXPIRY_DATE
------------------------------ -----------------
JEFF

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms