CA AuthMinder 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 AuthMinder Server.

Note: See the Oracle database documentation for details on performing the tasks that are listed in the following sections.

Required Tablespaces

Running AuthMinder 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 AuthMinder 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.

Database Configuration Script

The 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 should manually create this tablespace and delete the section in this script which creates the reports tablespace.

If a tablespace with that name already exists, then it is removed and re-created.

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 DBA's preferences. However, the tablespace name must be ARReports to generate reports successfully.

Perform the following steps to set up the Oracle database:

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