ORA 28002 the password will expire within 6 day
I have an Oracle database running on solaris 10, I was getting the following error when users where connecting to the database
Version= Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
“ORA-28002: the password will expire within 6 days”
I tried executing the following command but still error message were shown and accounts were still locking even after altering the passwords and unlocking
ALTER PROFILE DEFAULT PASSWORD_REUSE_MAX UNLIMITED;
I then altered the parameters to read the following:
ALTER PROFILE DEFAULT PASSWORD_REUSE_MAX UNLIMITED;
ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME 400;
ALTER PROFILE default LIMIT PASSWORD_GRACE_TIME 20;
ALTER PROFILE default LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
ALTER PROFILE default LIMIT IDLE_TIME UNLIMITED;
Im getting locks and one user very slow and locks
Below are some output
bash-3.00$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 28 15:12:09 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select LIMIT, RESOURCE_NAME from dba_profiles where RESOURCE_NAME in ('PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME','PASSWORD_REUSE_MAX','PASSWORD_REUSE_TIME') and PROFILE=(select profile from dba_users where username='LEGAL');
LIMIT RESOURCE_NAME
---------------------------------------- --------------------------------
400 PASSWORD_LIFE_TIME
UNLIMITED PASSWORD_REUSE_TIME
UNLIMITED PASSWORD_REUSE_MAX
20 PASSWORD_GRACE_TIME
SQL> select ctime, ptime from sys.user$ where name='LEGAL';
CTIME PTIME
--------- ---------
30-APR-11 28-OCT-11