Oracle

1. See the Oracle Administrator's Guide for details on how to create an Oracle database.
2. The following scripts for Oracle are part of the FTM Product installation. These scripts must be installed on the Oracle server an will be used to create the FTM database artifacts (for example, tablespaces, tables, views).

   File	Description
   MakeCoreDB.sh	Main UNIX script to create the FTM database artifacts
   MakeCoreDB.cmd	Main Windows script to create the database. Optional - contained in FXH_Core_Database_ORA_LUW.zip
   00-CreateDB_AIX.ddl	DDL for tablespaces and FTM user
   00-CreateDB-Win.ddl	Windows DDL for tablespaces and FTM user. Optional - contained in FXH_Core_Database_ORA_LUW.zip
   01-FTMDB.ddl	DDL for tables
   02-NewID.sql	DDL for sequences, procedures, and functions Note: This script may be configured with regards to ID management settings - Generation and Caching, Instance and Partition support. For more information, see ID Management.
   02a-TimestampFunctions.sql	Time stamp and time zone functions
   03-ObjTrig.sql	DDL for triggers
   04-Views.sql	DDL for views
   05-Indices.sql	DDL for indices
   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	DDL for service participant views
   14-ViewsSchedTask.sql	DDL for scheduler task views
   15-ConfigSPs.sql	DDL for stored procedures
   16-HistTrigs.sql	DDL for triggers
   17-ConfigIDGen.sql	ID generation value table entries Note: This script may be configured with regards to ID management settings - Generation and Caching, Instance and Partition support. For more information, see ID Management.
   18-ViewDefns.sql	View definition value table entries
   19-Config.sql	VALUE table entries for configuration
   FTMConfig.sh	Configuration variables

   Edit one of the following files to modify the parameters that are listed in the Oracle database parameters table.

   On AIX®:

   FTMConfig.sh

   On Windows:

   FTMConfig.cmd

   Table 1. 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 to the Oracle user who is creating the Oracle instance
   FTMROLE	"FTMRole"	The name of the Oracle role that will be created with the required 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 allocated to the datafile
   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 allocated to the datafile
   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 allocated to the datafile
   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 required. The default parameters also include minimum and maximum tablespace sizes to limit the size of the database. These should be revised to ensure that the tablespace configurations meet the requirements of your system.
3. Before running any of the AIX shell scripts (.sh) for setup it may be necessary to grant execute privileges to these files with the chmod command.
4. The scripts will have to be run by a user that has Oracle administrator rights and has read and write access to the directories that are to be used by the scripts to create the FTM database artifacts.
5. Run the script MakeCoreDB.sh (on AIX) or MakeCoreDB.cmd (on Windows). For example, enter:

   . MakeCoreDB.sh

Once this procedure is completed, the Oracle database and FTM database artifacts have been created.