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.    Reference: Oracle Documentation     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> 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> PASSWORD    Changing password for SCOTT    Old password:    New password:    Retype new password:    Password changed