Silicon Technix

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

[oracle@db ~]$ 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@db ~]$ 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