Setting up GainSeeker on an Oracle database

Your Oracle database administrator (DBA) must perform the following steps:

  1. Create new tablespaces named SPC and SPCIDX. Two variations of the example script for creating the tablespaces and tables, SPC8_ORC.SQL, are provided in the \Scripts\Oracle\ and \Scripts\Oracle\Expanded\ folders in the GainSeeker installation package, but both use the same SQL statements to create the database.

If you need to use different names for these tablespaces, you will need to update the Data_Tablespace= and Index_Tablespace= settings in the Settings.hsi file after installing GainSeeker.

  1. Create a new User with the role of DBA, so that they can create and populate the necessary GainSeeker tables.

  2. Log in to Oracle as the new User, and then create all necessary tables in the GainSeeker database. A script for creating and populating the necessary tables, SPC8_ORC.SQL, is provided in the \Scripts\Oracle\ folder in the GainSeeker installation package.

 

After setting up the database, you can install the GainSeeker client on each workstation.