Your Oracle database administrator (DBA) must perform the following steps:
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.
Create a new User with the role of DBA, so that they can create and populate the necessary GainSeeker tables.
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.
If you plan to use the typical GainSeeker table structures, use the SPC8_ORC.SQL script in the \Scripts\Oracle\ folder.
If you plan to use Expanded data fields, use the SPC8_ORC.SQL script in the \Scripts\Oracle\Expanded\ folder and update the constants DBPSD, DBPD, and DBUDL to the desired field lengths.
After setting up the database, you can install the GainSeeker client on each workstation.
When the first GainSeeker client installation prompts you to enter the Oracle Server Name, you should specify the Oracle Net Service Name you have set up on the workstation.
If you used the script for expanded data fields, you must use the GainSeeker System Administration module to set the field lengths for the Initial Configuration:
Go to the settings for Tables and File Paths and click the Expand button. This will display the Expand Column Lengths window with default column lengths.
Set the three column lengths to match the three constants in the script you executed, then click OK.