Configuring Oracle Database

You will need to run a number of scripts to configure the Oracle database.

Executing the scripts

Procedure

Before executing the script files for Oracle implementation, you must manually create the database for Relational Replication.

Execute the scripts in the order given below. Based on the prefix (Temenos Transact/RR) in the script file name execute them in the respective database/schema. Read the comment section before executing the script files. You might need to perform a few customizations based on your target table naming convention.

1. 1_T24_TABLE_CREATE_SCRIPT

2. 2_T24_JOB_CREATION_SCRIPTS

3. 3_RR_DB_SCHEMA_USER_CREATION

4. 4.1_RR_CONFIG_TABLE_SCRIPTS

5. 4.2_RR_CONFIG_VIEW_SCRIPTS

6. 4.3_RR_CONFIG_PLSQL_PACKAGE_SCRIPTS

7. 5_RR_CONFIG_INSERT_SCRIPTS

8. 6_RR_METADATA_TABLE_SCRIPTS

9. 7_RR_METADATA_VIEW_SCRIPTS

10. 8_RR_DELETE_LOG_MGMT_TABLE_SCRIPTS

11. 9_STMT_ENTRY_PARTITION_CREATION

12. 10.1_T24_DASHBOARD_SCRIPTS

13. 10.2_RR_DASHBOARD_SCRIPTS

1_T24_TABLE_CREATE_SCRIPT

Execute the script against the live (Temenos Transact) database.

This script will drop and recreate the F_DATA_EVENTS table in the Temenos Transact Database with the required partitions and indexes to improve the performance of the ETL and purge process.

2_T24_JOB_CREATION_SCRIPTS

Execute the scripts against the live (Temenos Transact) database.

These scripts will create tables, views and functions in the Temenos Transact database.

3_RR_DB_SCHEMA_USER_CREATION

Execute the scripts against the Relational Replication database using SYSDBA privileges.

These scripts will:

1. Create tablespaces and temporary tablespaces.

2. Create users and grant them privileges, using values based on the target environments.

3. Change the password based on the requirement in the User Creation script.

4.1_RR_CONFIG_TABLE_SCRIPTS

These scripts will:

1. Execute scripts against the CONFIG schema in the Relational Replication database.

2. Create the configuration and staging tables and their indexes and sequences. The tables are created under the default table space defined using user creation. The indexes for the tables are created in the CONFINDX index space.

4.2_RR_CONFIG_VIEW_SCRIPTS

These scripts will:

1. Execute scripts against the CONFIG schema in the Relational Replication database.

2. Create Relational Replication monitoring views.

4.3_RR_CONFIG_PLSQL_PACKAGE_SCRIPTS

These scripts will:

1. Execute scripts against the CONFIG schema in the Relational Replication database.

2. Create PL/SQL procedures for the Relational Replicaton retry process.

5_RR_CONFIG_INSERT_SCRIPTS

These scripts will:

1. Execute scripts against the CONFIG schema in the Relational Replication database.

2. Insert SQL’s for the default Configuration Parameters required for Relational Replication applications (Config, ETL and Purge).

6_RR_METADATA_TABLE_SCRIPTS

These scripts will:

1. Execute scripts against the MDATA schema in the Relational Replication database.

2. Create tables and indexes to hold the Relational Replication metadata. These are created under the default table space defined during user creation. Their indexes are created in the METAINDX index space.

7_RR_METADATA_VIEW_SCRIPTS

These scripts will:

1. Execute scripts against the MDATA schema in the Relational Replication database.

2. Create metadata views.

3. GRANT statements which allow RR user to access the MDT_VIEW in the MDATA Schema.

8_RR_DELETE_LOG_MGMT_TABLE_SCRIPTS

These scripts will:

1. Execute scripts against the RR schema in the Relational Replication database.

2. Create table RR_DELETE_LOG_MGMT.

9_STMT_ENTRY_PARTITION_CREATION

This script will execute scripts against the RR schema in the Relational Replication database.

This script is used to improve performance for STMT.ENTRY related enquries. It may not be required if enquiries are not in the Relational Replication produce scope.

If used, it has to be enacted immediately after the STMT.ENTRY Table Replication (XSD Schema Replication) and before the Replication of Data Events (Data Event Replication) from Temenos Transact to RR

10.1_T24_DASHBOARD_SCRIPTS

These scripts will:

1. Execute scripts against the live Temenos Transact database.

2. Create the view, synonym and database link in the live database required for Relational Replication dashboard enquiries.

10.2_RR_DASHBOARD_SCRIPTS

These scripts will:

1. Execute scripts against the RR scheme in the Relational Replication database.

2. Create the view and synonym in the Relational Replication database required for Relational Replication dashboard enquiries