Update Shell Database

  1. Navigate to the latest Inventory Management release 9.1 patch installation media, unzip <date>_HIM_DBMaintenance(64-bit)_9.1.x.x.x.zip in <drive:>\IMSetup\91Patchx. Use the appropriate 32-bit or 64-bit version for your system and for the Oracle Client.
  2. During the installation, select a path other then default one. Do not install in the Program Files folder. Then, enter the Oracle instance name.
  3. From installation directory of the Database Maintenance application, edit sql.config in a text editor. Verify server names and add others if necessary. The values in bold are specific to your environment:
    <servers>
    <server name=“<Oracle Server Instance>”><DbBrand value=“ORACLE”/>
    <ServiceName value=“<Oracle Server Instance>”/>
    </server>
    </servers>
  4. From the installation directory of the Database Maintenance application:
    1. Edit FMLOGIN.INI and update and save:
      DBLogin=<Oracle Server Instance>/<User(Organization Short Name)>/<user password>,<Organization Short Name>,myinvenMenu.ini
    2. Refer to the Oracle MICROS Inventory Management Security Guide to configure the FMLOGIN.INI.
    3. If you are performing parallel database updates, you can set the maximum number of parallel updates by adding or setting the following lines:
      [BatchUpdate]
      MaxThreads=number of threads

      Depending on your hardware configuration, enter a value between 10 and 30 for MaxThreads.

  5. Run the database update for either a single database or multiple databases. On your desktop open either:
    • Single Database Maintenance and then sign in with the user Admin and password changeme.
      1. Click Settings and then select Daily Totals.

      2. Click Database Update and then select Database Update to insert the tables, columns, and views. Verify that the update completes without errors.

      3. Select Reorganization to add and remove database procedures and functions. Verify that the update completes without errors.

    • Batch Database Maintenance, select one or more databases, and then click Update and Reorganize or Reorganize Only.