CA Strong Authentication UNIX Installation Guide › CA Strong Authentication Configuration for Oracle RAC › Modify the Database Script

Modify the Database Script

You run the database scripts as a post-installation task in the CA Strong Authentication installation procedure. 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-8.0.sql file. This file is in the install_location/arcot/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:

   • Replace shared_location with the shared datafile path that you determined by running the command given in the first step.
   • 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.