8.7.1 Modify OFSAA Infrastructure Config Schema Password

To change the Config Schema password, perform the following steps:

  1. Change the Config schema User Password in the database.
  2. Delete the $FIC_HOME/conf/Reveleus.SEC file.
  3. Shutdown the OFSAAI App service: cd $FIC_APP_HOME/common/FICServer/bin ./stopofsaai.sh
  4. Start the Infrastructure Server in foreground directly on the server or through X-Windows software using the command: ./startofsaai.sh
  5. At the prompt, enter System Password. Enter the "new Config schema" password. The service will start and initialize itself if it can successfully connect to the DB.
    • 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 a web server, follow these steps:
    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 a web server, follow these steps:
    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. Post successful startup of the service, if required, the Infrastructure server may be shut down and restarted in the background using nohup mode.