Archive for March, 2014

Introduction to NoSQL by Martin Fowler

March 3, 2014

Advertisements

Set password for local oracle accounts and let them never expire again

March 3, 2014

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)