8 Database Updater

DBupdater is a tool that run and update the database using scripts. When the DBupdater is installed, follow the below settings to allow DBupdater to run.
  1. In Environmental Variables, enter TNS_ADMIN as environment variable name and the variable value is the path to Network folder of ODAC).
  2. Your TNS file must be placed in the admin folder.
  3. Copy the scripts into the script folder.
  4. Add the scripts sequence in Sequence.txt.
  5. Modify project.properties file, which is placed under the Config, to update the ServiceURL for OHCFMSSecurityWebService.

Database Updater Login Screen

Figure 8-1 The Database Updater Login Screen


This figure shows the login screen for the database updater application.
  1. Enter your FMS username.
  2. Enter your FMS password.
  3. Browse the tnsnames.ora location on your system.
  4. Select the datasource that you want to connect.
When you are successfully validated, the system will access the main screen.

Figure 8-2 Establish Connection screen


This figure shows the Establish Connection screen.

The Run Scripts button will only enable when you enter a valid credential. Once logged in, you can select the scripts you want to run followed by Run Scripts.