Oracle - Database | Troubleshooting

Issue / Error Message: ORA-28001: the password has expired
View More

Scenario: Database connection is failing. You either see this error in application log that is not starting because it is not able to connect to database OR you are using some tools/IDE to connect to database and see the above error

Cause: The user database password that you are using to connect in your application or IDE has expired

Solution: Login as other user and reset the expired user password or ask your DBA to do so.

alter profile default limit password_life_time unlimited;

alter user <username> identified by <password>;

Caution: It is better to connect with your DBA before changing any such values unless you are trying out anything in development/evaluation kind of environment.