CA Risk Authentication Windows Installation Guide › Pre-Installation Tasks › Configure Database Server › Configure Oracle Server

Configure Oracle Server

This section provides the configuration information for creating Oracle database server.

Prerequisites:

1. Run CA Risk Authentication on Oracle with two table-spaces. The reasons to have two table-spaces are as follows:
   • Use the first table-space for configuration data, audit logs, and user information. This table-space can be the default user table-space in the CA Risk Authentication database.
   • Run the reports on the second table-space. We recommend that you use a separate table-space to run the reports.
2. Use CA Risk Authentication Database Configuration Script. The script automatically creates the table-space for reports, if the database user running the script has sufficient permissions to create a table-space. If the user does not have the required permissions, the db administrator must manually create this table-space and delete the section for creating reports in the script.

   arcot-db-config-for-common-8.0.sql
   

   Important! The parameters for creating the reports table-space in the arcot-db-config-for-common-8.0.sql database script can be changed according to the preferences of the db administrator. However, the table-space name must be ARReports to generate reports successfully.

To create an Oracle server, perform the following steps:

1. Create a new database that stores information in the UTF-8 character set. This allows CA Risk Authentication to use international characters including double-byte languages. To enable UTF-8 support for your Oracle database perform the following steps:
   1. Log in to the Oracle database server as SYS or SYSTEM.
   2. Run the following command:

      sys.props$ set value$='UTF8' 
      

      (where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET')

   3. Restart the database and verify whether the character set is configured to UTF-8.
2. Create a database user:
   1. Create a user (recommended name is arcotuser), with a schema in the new database arcotdb.
   2. Set the quota of user to at least 5 GB to 10 GB for a development or test deployment.

      Note: If the deployment is for the production environment, staging, or other intensive testing, see Database Reference to determine the quota that is required for a user.

   3. Grant the DBA role to the user.