Blog
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: 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