CA Risk Authentication UNIX Installation Guide › CA Risk Authentication Configuration for Oracle RAC

CA Risk Authentication Configuration for Oracle RAC

Perform the steps in this section if you want to use Oracle RAC with CA Risk Authentication 8.0.

Update the arcot-db-config-for-common-2.0.sql Script

You run database scripts as a arcot-db-config-for-common-2.0.sql script post-installation task. Before you run this script, modify it for Oracle RAC.

Follow these steps:

1. To determine the Oracle RAC shared datafile path, log in to the database and run the following command:

   SELECT file_name, tablespace_name FROM dba_data_files
   

   The following is sample output of this command:

   +DATA\qadb\datafile\users.259.797224649	USERS
   +DATA\qadb\datafile\undotbs1.258.797224649	UNDOTBS1
   +DATA\qadb\datafile\sysaux.257.797224647	SYSAUX
   

2. Open the arcot-db-config-for-common-2.0.sql file. This file is in the install_location\Arcot Systems\dbscripts\oracle\ directory.
3. Search for the following line in the file:

   filename varchar2(50) := 'tabspace_arreports_'|| to_char(current_timestamp, 'YYYY-MM-DD-HH24-MI-SS') || '.dat';
   

4. Replace that line with the following line:

   filename varchar2(100) := '+shared_location/service_name/datafile/tabspace_arreports_'|| to_char(current_timestamp, 'YYYY-MM-DD-HH24-MI-SS') || '.dat';
   

   In the new line:

   1. Replace shared_location with the shared datafile path that you determined by running the command given in the first step.
   2. Replace service_name with the service name of the Oracle RAC installation.

   The following is a sample line:

   filename varchar2(100) := '+DATA/forwardinc/datafile/tabspace_arreports_'|| to_char(current_timestamp, 'YYYY-MM-DD-HH24-MI-SS') || '.dat';
   

5. Save and close the script file, and then run it.