- 10 Nov, 2021
- 0 Comments
- 1 Min Read
ORA-28002: the password will expire within 7 days
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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | [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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 | [oracle@lnxsvr ~]$ sqlplus scott/tigerSQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.ERROR:ORA-28002: the password will expire within 7 daysConnected to:Oracle Database 11g Release 11.2.0.1.0 - 64bit ProductionSQL> connect / as sysdbaConnected.SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';PROFILE------------------------------DEFAULTSQL> SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'AND RESOURCE_NAME='PASSWORD_LIFE_TIME';LIMIT----------------------------------------60SQL> 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/tigerConnected.SQL> PASSWORDChanging password for SCOTTOld password:New password:Retype new password:Password changed |