Issue: The password for the OPSS database account changes

This issue occurs when the password for the EMPIRICA_OPSS account expires or changes, for example, due to password expiration policies.

Resolution:

You must register the new password in the following locations:

The bootstrap wallet file

1. In a command shell, navigate to the directory for the bootstrap wallet file using a command such as:

   $ cd /u01/app/oracle/Middleware12c/user-projects/domains/empirica/config/fmwconfig

2. In a command shell, start WLST using a command such as:

   $ /u01/app/oracle/Middleware12c/oracle_common/common/bin/wlst.sh

   The following prompt appears:

   wls:/offline>

3. Execute the following command:

   modifyBootStrapCredential(jpsConfigFile='./jps-config.xml',
   username='< user >', password='< new password >')

   where:

   • < user > is the name of the OPSS schema database account, such as EMPIRICA_OPSS.
   • < new password > is the new password of the OPSS schema database account.
4. To exit WLST, execute the exit() command.

The data source associated with the OPSS schema database account

1. Open the Oracle WebLogic Server Administration Console.
2. Expand Services, and select Data Sources.
3. Select the Data Source entry.

   If you followed the recommendations in Create a data source for credential access, the data source is named Empirica Credential Store, and the JDNI name is jdbc/mds/opss.

4. Select the Configuration tab, and select the Connection Pool tab.
5. In the Change Center section on the left, click Lock & Edit.
6. Scroll to the Password and Confirm Password fields.
7. Enter the account password in both fields, and click Save.
8. In the Change Center section on the left, click Activate Changes.