Created On:  09 December 2010

Problem:

When user attempts to open Workspace in Modernization Workbench, receives error Database Connection Failed.  The specific error message received is ORA-28001: The password has expired.

Resolution:

The password for the corresponding database user has expired and needs to be changed.  In addition, the Oracle environment can be modified to allow for no expirations of passwords in the future.

The simplest method to reestablish the password is to connect directly to the database using SQLPlus.  Once completed, user will prompted to change the password.  The same password can be used as the "new" password and the expiration will have been lifted.  The user's DBA can also be used to change the password in the event that the user can not directly do so.

Once the passwords are enabled again, the user or DBA can run the following command to lift the password expiration restriction.

ALTER PROFILE DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED;
Incident #2488591