The database password for config schema and atomic schema should be changed periodically for security. The following configurations are required on changing the database passwords:
For changing CONFIG schema password:
1. Log in to the database and change the config schema password.
2. Log in to the OFSAA server.
3. Stop all OFSAA services.
4. Delete Reveleus.sec from FIC_HOME/conf.
5. Restart OFSAA service in foreground (without the nohup option).
6. Enter the latest config schema password when you are prompted at the console.
For changing the ATOMIC schema password:
1. Ensure the OFSAA services are running and application can be accessed.
2. Log in to the database and change the ATOMIC schema password.
3. Log in to the OFSAA application as any user with System Administrator privilege.
4. Navigate to System Configuration and Identity Management > Administration and Configuration > Database Details.
5. Modify the Password field with the new password and click Save. For more information, see OFSAAI User Guide.
6. Navigate to Data Management Framework > Data Sources.
7. Select the appropriate Data Source pointing to the ATOMIC Schema for which the password was reset from the Data Sources tree.
8. Click Edit.
9. Modify the Password field with the new password and click Save. For more information, see OFSAAI User Guide.
Resource Reference/ JNDI connection details
On change of the CONFIG/ ATOMIC schema passwords, the corresponding Resource Reference/ JNDI connection entries made in the Web Application Servers need to be updated.
· For Tomcat Web Server.
§ Stop the Tomcat Server.
§ Update the Server.xml file present in $CATALINA_HOME/conf with the latest config schema and atomic schema passwords.
· For WebSphere / WebLogic
§ Access the server specific “Admin” console.
§ Log in to the server with Administrative privileges.
§ Update DataSources with the latest config schema and atomic schema passwords. For more information, see the Configuring Resource Reference sections in Appendix B in OFS AAAI Application Pack Installation and Configuration Guide available in OHC Documentation Library.