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.
Reference: Oracle Documentation
[roboshot url=”https://blogs.silicontechnix.com/?p=945″ width=”80″ newpage=”TRUE”]
Solutions:
1) Simply change the password to avoid it temporary
01 | [oracle@db ~]$ sqlplus scott/tiger |
03 | SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012 |
05 | Copyright (c) 1982, 2009, Oracle. All rights reserved. |
08 | ORA-28002: the password will expire within 7 days |
11 | Oracle Database 11g Release 11.2.0.1.0 - 64bit Production |
14 | Changing password for SCOTT |
2) Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITED
then change the password to avoid it permanently
01 | [oracle@db ~]$ sqlplus scott/tiger |
03 | SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012 |
05 | Copyright (c) 1982, 2009, Oracle. All rights reserved. |
08 | ORA-28002: the password will expire within 7 days |
11 | Oracle Database 11g Release 11.2.0.1.0 - 64bit Production |
13 | SQL> connect / as sysdba |
16 | SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT'; |
22 | SQL> SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' |
23 | AND RESOURCE_NAME='PASSWORD_LIFE_TIME'; |
29 | SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; |
33 | SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT'; |
1 | SQL> connect scott/tiger |
5 | Changing password for SCOTT |
