Tag Archives: ORA-28001

How to solve ORA-28001: The password has expired

https://www.techengineer.one/how-to-solve-ora-28001-the-password-has-expired/   The other day I was happily opening SQL Developer when I found this horrible thing. Here is how to solve it. Connect as sysdba to the database. C:\Users\Siry>sqlplus / as sysdba Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. Set a […]