Oracle

  1. See the Oracle Administrator's Guide for details on how to create an Oracle Database.
  2. The scripts for Oracle in the following table are provided with the FTM installation. These scripts must be installed on the Oracle server and are used to create the FTM database artifacts (for example, table spaces, tables, views).
    Table 1. Oracle Database scripts
    File name Description
    MakeCoreDB.cmd Main Windows script to create the database. This script is optional and is contained in FXH_Core_Database_ORA_LUW.zip.
    MakeCoreDB.sh Main UNIX script to create the database artifacts.
    00-CreateDB_AIX.ddl The DDL for table spaces and FTM user.
    00-CreateDB-Win.ddl Windows DDL for table spaces and FTM user. This script is optional and is contained in FXH_Core_Database_ORA_LUW.zip.
    01-FTMDB.ddl The DDL for tables.
    02-NewID.sql The DDL for sequences, procedures, and functions.
    Note: This script can be configured with regards to ID management settings - Generation and Caching, Instance, and Partition support. For more information, see ID Management.
    02a-TimestampFunctions.sql Timestamp and time zone functions.
    03-ObjTrig.sql The DDL for triggers.
    04-Views.sql The DDL for views.
    05-Indices.sql The DDL for indexes.
    06-UpViewPt.sql Updatable view definition for Transmission objects.
    07-UpViewTxn.sql Updatable view definition for Transaction objects.
    08-UpViewPay.sql Updatable view definition for Payment objects.
    09-UpViewSec.sql Updatable view definition for Securities objects.
    10-UpViewBat.sql Updatable view definition for Batch objects.
    11-UpViewFrag.sql Updatable view definition for Fragment objects.
    12-UpViewActivity.sql Updatable view definition for Activity objects.
    13-ViewSvcPart.sql The DDL for service participant views.
    14-ViewsSchedTask.sql The DDL for scheduler task views.
    15-ConfigSPs.sql The DDL for stored procedures.
    16-HistTrigs.sql The DDL for triggers.
    17-ConfigIDGen.sql The ID generation value table entries.
    Note: This script can be configured with regards to ID management settings - Generation and Caching, Instance, and Partition support. For more information, see ID Management.
    18-ViewDefns.sql The view definition value table entries.
    19-Config.sql VALUE table entries for configuration.
    FTMConfig.sh Configuration variables.
    Edit one of the following script files to modify the parameters that are listed in the Oracle Database parameters table.
    On AIX®
    FTMConfig.sh
    On Windows
    FTMConfig.cmd
    The following table shows some of the parameters that are set in these script files.
    Table 2. Oracle Database parameters
    Parameter Default value Description
    DBNAME "FTMDB" The name of the Oracle Database that was created in step 1.
    FTMSCHEMA "FTM" The schema name.
    FTMUNAME "FTM" Change this parameter to the Oracle user who is creating the Oracle instance.
    FTMROLE "FTMRole" The name of the Oracle role that is to be created with the necessary authorizations and applied to the FTMUNAME user.
    PATHDIV '/' The path name separator.
    DB_HOME '/home/oracle' The path to the disk area where the database container files are created.
    BASIC_SEGMENT_SIZE '1M' Used by the CREATE TABLESPACE commands to define the size that is allocated to the data file.
    BASIC_SEGMENT_MXSIZE '50M' Used by the CREATE TABLESPACE commands to define the autoextend maxsize limit.
    MEDIUM_SEGMENT_SIZE '2M' Used by the CREATE TABLESPACE commands to define the size that is allocated to the data file.
    MEDIUM_SEGMENT_MXSIZE '100M' Used by the CREATE TABLESPACE commands to define the autoextend maxsize limit.
    HIGH_SEGMENT_SIZE '10M' Used by the CREATE TABLESPACE commands to define the size that is allocated to the data file.
    HIGH_SEGMENT_MXSIZE '500M' Used by the CREATE TABLESPACE commands to define the autoextend maxsize limit.
    Note: Many of these settings are different from the standard Oracle defaults. Modify them as needed. The default parameters also include minimum and maximum table space sizes to limit the size of the database. These defaults need to be revised to ensure that the table space configuration meets the needs of your system.
  3. Before any of the AIX shell scripts (.sh) for setup are run, it might be necessary to grant execute privileges to these files by using the chmod command.
  4. The scripts must be run by a user that has Oracle administrator privileges. The user must also have read and write access to the directories that are to be used by the scripts to create the FTM database artifacts.
  5. Run the MakeCoreDB.sh (on AIX) or MakeCoreDB.cmd (on Windows) script. For example, 
    . MakeCoreDB.sh

After this procedure is complete, the Oracle Database and FTM database artifacts were created.