CA Strong Authentication UNIX Installation Guide › How to Configure the Database Server › Oracle Database Configuration

Oracle Database Configuration

This section provides the configuration information for Oracle Database and CA Strong Authentication Server.

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

Running CA Strong Authentication 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.

  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.

If the database user running the script has sufficient permissions to create a tablespace, the database configuration script (arcot-db-config-for-common-8.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-8.0.sql database script can be changed according to the DBA's preferences. However, ensure that the tablespace name is ARReports.