Creating Databases for TIBCO Fulfillment Order Management 4.0

For TIBCO Fulfillment Order Management 4.0, you are required to have two databases: the admin database and the default tenant database. You are required to create a new admin database, and the backed up TIBCO Fulfillment Order Management 3.0.2 HF-4 database is used as the default tenant database.

1. Create the admin database by executing $AF_HOME/db/oracle/oms/OMS_AdminDatabase_DDL.sql
   Note: The "admin" database is just a naming convention that is used for this newly created database. The user for the admin database should have the usual database rights as mentioned in $AF_HOME/db/oracle/oms/createOMSUser.sql.
2. Grant the existing database user on TIBCO Fulfillment Order Management 3.0.2 HF-4 the rights to create a database link by logging into the Oracle database as sysdba and execute:

    SQL> GRANT CREATE DATABASE LINK TO <fom-302-db-user>;