Installation Guide for Oracle Database with Red Hat JBoss

10.3

Back Next

Step 2. Set Up Database Instances

After you install and configure Oracle Database, create and set up database instances.

The following table describes the tasks that you need to perform to set up a database instance:

Tasks	Description
Create a database instance	Create a database instance. For an MDM Hub with multiple Operational Reference Stores distributed across different host machines, create a database instance on each host machine.
Create tablespaces	Create tablespaces for the MDM Hub data. Adjust the default tablespace sizes and the number of data files based on the volume of data that you want to load into the MDM Hub. Create the following tablespaces: CMX_DATA. Contains the metadata and user data of the MDM Hub. CMX_INDX. Contains indexes that the MDM Hub creates and uses. CMX_TEMP. Contains temporary tables for the MDM Hub. BPM_DATA. Contains the ActiveVOS data for business process management.

Tasks

Description

Create a database instance

Create a database instance. For an MDM Hub with multiple Operational Reference Stores distributed across different host machines, create a database instance on each host machine.

Create tablespaces

Create tablespaces for the MDM Hub data. Adjust the default tablespace sizes and the number of data files based on the volume of data that you want to load into the MDM Hub.

Create the following tablespaces:

CMX_DATA. Contains the metadata and user data of the MDM Hub.

CMX_INDX. Contains indexes that the MDM Hub creates and uses.

CMX_TEMP. Contains temporary tables for the MDM Hub.

BPM_DATA. Contains the ActiveVOS data for business process management.

Set Up the Database Environment

Creating Tablespaces on Premises

Creating Tablespaces in Amazon Relational Database Service

Configuring the Database Environment for Custom Tablespace Names

Download Guide

Watch

Comments