Migrating the Database

Configure and then execute the upgrade-fom3.0.2hf4-to-fom4.0.0.sql script to migrate the database.

Prerequisites

If you have TIBCO Fulfillment Order Management 3.0.2 non-partitioned database, you must first convert your non-partitioned database to a partitioned database and then migrate your database. For steps to convert your non-partitioned database to a partitioned database, see Converting from a Non-Partitioned Database to a Partitioned Database.

Procedure

  1. Configure the $AF_HOME/db/oracle/oms/upgrade-fom3.0.2hf4-to-fom4.0.0.sql script with the correct values for the following substitution variables:
    Substitution Variable Description
    &1 Enter the default tenant tablespace name. There are some tables to be added in the default tenant database, so provide the tablespace name for the database which will be used as default tenant.
    Note: The following substitution variables are related to the admin database you have created in GUID-B0B445A5-30E4-46CF-A17C-5209393109F5.html#GUID-B0B445A5-30E4-46CF-A17C-5209393109F5__STEP_3B15CF332D10440D88D9B059B7871BD0_unique_7.
    &2 Enter the admin database user name.
    &3 Enter the admin database password.
    &4 Enter the host machine IP address where the admin database is created.
    &5 Enter the host machine port number to connect to the admin database.
    &6 Enter the service name to connect to the admin database.
    &7 Enter the default tenant user name.
  2. Execute the migrate script: 
    SQL> @upgrade-fom3.0.2hf4-to-fom4.0.0.sql <tablespace-name> <admin-username> <admin-password> <ip-address> <port> <service-name> <default tenant username>