ORA-28001: the password has expired

 

When you encounter an oracle error ORA-28001: the password has expired and you do not have sysdba priviledge, here is how to handle it.

What you need is sqlplus, which is located in ORACLE_HOME/bin. The step to resolve this are:

1. Login to you account by using sqlplus in command prompt

    c:\sqlplus or $sqlplus

2. Enter your user and the service

    Enter user-name: user@service

3. Enter your password when prompted to do so, and you will get the error ORA-28001

    Enter password:

    ERROR:
    ORA-28001: the password has expired

4. Then it will prompt for password change, you need to enter your new password twice.

    Changing password for user
    New password:
    Retype new password:
    Password changed

Then you will be able to login to the system.

 

Posted in: Ora Error