Your Oracle database administrator (DBA) must perform the following steps:
Create new tablespaces named SPC and SPCIDX. Locate the script for creating the tablespaces and tables, SPC8_ORC.SQL, in the \Scripts\Oracle\ folder in the GainSeeker installation package.
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 Expanded data fields, edit the script and update the constants DBPSD, DBPD, and DBUDL to the desired field lengths.
If you plan to use Additional traceability columns, edit the script and add columns to the DDAT_AUX, VDAT_AUX, and VMON_AUX tables (see comments in the script file)..
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 edited the script for expanded data fields or additional traceability columns, you must use the GainSeeker System Administration module to set the field lengths or additional traceability columns on the Initial Configuration:
Go to the settings for Tables and File Paths and click the Expand column length and/or the Additional Traceability Columns button and set the appropriate values.