Blog

ORA-28002: the password will expire within 7 days

Cause: The user's account is about to about to expire and the password needs to be changed.

Action: Change the password or contact the database administrator.

Solutions:

1) Simply change the password to avoid it temporary

 [oracle@lnxsvr ~]$ sqlplus scott/tiger

  SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012

  Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  ERROR:
  ORA-28002: the password will expire within 7 days

  Connected to:
  Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

  SQL> PASSWORD
  Changing password for SCOTT
  Old password:
  New password:
  Retype new password:
  Password changed

2) Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITED then change the password to avoid it permanently

 [oracle@lnxsvr ~]$ sqlplus scott/tiger

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-28002: the password will expire within 7 days

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL> connect / as sysdba
Connected.

SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';

PROFILE
------------------------------
DEFAULT

SQL> SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'
AND RESOURCE_NAME='PASSWORD_LIFE_TIME';

LIMIT
----------------------------------------
60

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';

ACCOUNT_STATUS
--------------------------------
EXPIRED(GRACE)

SQL> connect scott/tiger
Connected.

SQL> PASSWORD
Changing password for SCOTT
Old password:
New password:
Retype new password:
Password changed

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.