8.7.2 Modify OFSAA Infrastructure Atomic Schema Password

To change the Atomic Schema password, follow these steps:

1. Change the Atomic schema User Password in the database.
2. Log in to the application from the browser using the SYSADMN account or any user ID which has a System Administrator role mapped.
3. Navigate to System Configuration > Database Details window. Modify the password as explained in the following steps:
   1. From the Database Master window, select the connection whose password you want to modify and click the button from the toolbar.
   2. Click the button corresponding to the Alias Name. The Alias Details window is displayed.
   3. Modify the password in the Auth String field.
   • If you are using Apache Tomcat as the Web server, update the <Context> -> Resource tag details in the Server.xml file from the $CATALINA_HOME/conf directory. For Tomcat, both Config Schema (FICMASTER resource) and Atomic Schema (<INFODOM_NAME> resource) exist.
   • If you are using WebSphere as Web server:
   1. Log in to the WebSphere Administration Console, from the left side menu.
   2. Navigate to Resources >JDBC >Data Sources. A list of data sources are populated on the right side.
   3. Select the appropriate Data Source and edit the connection details. (In this case, both Config and Atomic data sources must be modified).
   • If you are using WebLogic as Web server:
   1. Log in to the WebLogic Administration Console, from the left side menu.
   2. Under Domain Structure list box, expand the appropriate Domain and navigate to Services > JDBC >Data Sources. A list of data sources are populated on the right side.
   3. Select the appropriate Data Source and edit the connection details. (In this case, both Config and Atomic data sources must be modified).
4. Restart the OFSAAI services.