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

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)

Tags: , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: