Tuesday, August 6, 2013

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:
    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.