Using Oracle Application Clusters

  To set up Oracle databases in RAC:

1. Log into Oracle as the system database adminstrator.

2. Create a tablespace with these attributes:

   • size 1024m

   • autoextend on

   • next 256m

   • maxsize 5128m

   • extent management local

3. Create a user schema using the tablespace. The schema includes the user name and password Strategic Finance uses to access the export database.

4. Grant these privileges to the user schema:

   • CREATE PROCEDURE

   • CREATE SESSION

   • CREATE TABLE

   • UNLIMITED TABLESPACE

   • CONNECT

   • RESOURCE

5. Log in to the user schema.

6. In order, run these scripts:

   • Step1_tables_views.sql
     Contains the base and ancillary Strategic Finance database schema including tables, sequences, indexes, and keys

   • Step2_defaultspcreate.sql
     Contains defaults and substitution procedures.
     

   • Step3_pkgcreate.sql

     
     

     Contains package definitions and bodies for the base Strategic Finance database export and the customer interface table.

   • Step4a_optionalauditcreate.sql

     
     

     Contains optional audit table for defaults and substitutions.

   • Step4b_optionalaudittrigger

     
     

     Contains optional trigger for defaults and substitutions.