Tag Archives: SQL Developer

How to solve ORA-01017: Invalid username/password; logon denied

I was trying to connect to a database today when I found this: I think there could be a lot of reasons for this, but the easiest approach is to reset the user’s password, that is if the user exists of course. Here is the solution: Connect as sysdba to the database C:\Users\hecperez>sqlplus / as […]

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 […]