Blog

LearnoMate Technologies > Blog > Oracle DBA > ORA-28002: the password will expire within 7 days

ORA-28002: the password will expire within 7 days

  • November 10, 2021
  • Posted by: admin
  • Category: Oracle DBA
No Comments

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
ORA-28002