If you are a getting warning messages like this one on your local developer oracle installation,
java.sql.SQLWarning: ORA-28002: the password will expire within 1 days
then there are two easy step to avoid the situation that you are not able to login with a given database user.
Step 1: Set the passsword policy to never expire passwords. Execute this SQL Query with your SYSTEM database user.
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Step 2: The expiring database user accounts are not affected by the above statements. You have to set a password for them to get rid of the warning and only then is the password never expiring again. You just have to start your “Run SQL Commandline” oracle console and first connect via the sysdba user (don’t be afraid, you don’t need a password for that one).
connect / as sysdba;
When you are connected successfully, just change the password for any database user
alter user SYSTEM identified by NEWPASSWORD;
(Disclainer: I’m no fan of oracle, but in my workplace I have to use it)