ORA-28002: the password will expire within n days

Applies to: Database Management Software Oracle 11G all editions

Issue:  ORA-28002: the password will expire within n days

Example:

SQL> connect scott/tiger
ERROR:
ORA-28002: the password will expire within 2 days

Solution: 

 connect as sys user

SQL> connect sys as sysdba
Enter password:
Connected.

Select profile of user showing error

SQL>  select account_status, profile from dba_users where username='SCOTT';

ACCOUNT_STATUS                   PROFILE
-------------------------------- ------------------------------
EXPIRED(GRACE)                   DEFAULT

Change PASSWORD_LIFE_TIME to Unlimited

SQL> alter profile DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

Reset user password to current password

SQL> alter user SCOTT identified by tiger;

User altered.

Crosscheck using login

SQL> connect scott/tiger
Connected.

10 comments:

  1. thnQ very much Sharma.. it solved my problem too...

    ReplyDelete
    Replies
    1. Welcome Friend, Keep visiting this blog and subscribe for new updates.

      Delete
  2. Replies
    1. i have the same issue after running these commands i still have the same error.......
      what to do?

      Delete
  3. The system is unable to process your request. Please try again later. ORA-28001: the password has expired

    ReplyDelete
  4. The system is unable to process your request. Please try again later. ORA-28001: the password has expired

    ReplyDelete