CA RiskMinder Windows 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 the Oracle database documentation for details on 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, a DBA must manually create this tablespace and delete the section in this script, which creates the reports 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 the preferences of the DBA. However, the tablespace name must be ARReports to generate reports successfully.

To set up the Oracle database, perform the following steps:

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