Foundation: Resolving an expired Oracle Password

In the case the Hub schema password expires, it will need to be updated. If this does occur there are two options that can be taken by the user to restore it.

Option 1: Update the Schema user using the same password

Option 2: Update the Schema user with a new password

Both options will require the user to run a SQL script against the Oracle database that contains the user. For an example say the schema user name is "HubUser1" and the password is to be changed to "password". The SQL script the user would run is:

ALTER USER "HubUser1" IDENTIFIED BY "password";

Once this line has been entered and executed it will change the password. If the user chooses to do Option 2 then it is important to update the Hub Database password in the Hub Configuration page under admin and settings. Otherwise, Foundation will no longer be able to connect to the database until this is fixed. To find out how to fix this, click this link.