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.
- In a command shell, navigate to the directory for the bootstrap wallet file using a command such as:
$ cd /u01/app/oracle/Middleware/user-projects/domains/empirica/config/fmwconfig.
- In a command shell, start WLST using a command such as:
$ /u01/app/oracle/Middleware/oracle_common/common/bin/wlst.sh
The following prompt appears:
wls:/offline>
- 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.
- To exit WLST, execute the exit() command.
- In a command shell, navigate to the directory for the bootstrap wallet file using a command such as:
- The data source associated with the OPSS schema database account.
- Open the WebLogic Administration Console.
- Expand Services, and select Data Sources.
- 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.
- Select the Configuration tab, and select the Connection Pool tab.
- In the Change Center section on the left, click Lock & Edit.
- Scroll to the Password and Confirm Password fields.
- Enter the account password in both fields, and click Save.
- In the Change Center section on the left, click Activate Changes.