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

Note: See the Oracle Database documentation for details about 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

If the database user running the script has sufficient permissions to create a tablespace, the database configuration script (arcot-db-config-for-common-2.0.sql) automatically creates the reports tablespace. If the user does not have the required permissions, a DBA can manually create the reports tablespace and delete the section in this script that creates this 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, ensure that the tablespace name is ARReports.

Perform the following steps:

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