CA RiskMinder UNIX Installation Guide › Preparing for Installation › Configuring Database Server › Configuring Oracle Database

Configuring Oracle Database

This section provides the configuration information for Oracle Database and RiskMinder Server.

Note: See Oracle Database documentation for information about performing the tasks that are listed in the following sections.

Required Tablespaces

Running RiskMinder on Oracle requires two tablespaces:

• The first tablespace is used for configuration data, audit logs, and user information. This tablespace can be the default user tablespace in the RiskMinder database.

  See "Creating a New Database" for creating a database.

• The second tablespace is used to run reports. For high performance, it is recommended that you use a separate tablespace.

RiskMinder Database Configuration Script

The RiskMinder database configuration script, arcot-db-config-for-common-2.0.sql, automatically creates the tablespace for reports if the database user running the script has sufficient permissions to create a tablespace. If the user does not have the required permissions, delete the section in this script that creates the reports tablespace and manually create the tablespace.

Important! The parameters for creating the reports tablespace in the arcot-db-config-for-common-2.0.sql database script can be changed according to your requirements. However, the tablespace name must be ARReports.

Perform the following steps to set up Oracle Database:

1. Creating a New Database
2. Creating a Database User