Setting Up an Oracle GeneLinker™ Database

Overview

Using an Oracle GeneLinker™ database requires some preliminary setup.

Actions

1. If you do not already have access to a running Oracle database, install one. Visit the following site for full details: http://www.oracle.com/ip/deploy/database/oracle9i/

2. As the database administrator, create a database in Oracle called, for example, BIO_DB.

3. Create an account (user name and password) for accessing the BIO_DB database.

4. Configure your Oracle installation so that the BIO_DB database is accessible using the above account on the computer where GeneLinker™ is installed.

5. Run the OracleConfigurationUtility.bat application found in the Maintenance folder of the GeneLinker™ installation folder. You will be prompted for the name of the database (BIO_DB in this example), the user name, and password.

Warning: this password appears in plain text in the GeneLinker™ configuration file (GeneLinker.conf). Please take whatever precautions are required to secure this file or use a unique password for this application (to limit the risk if this password becomes known to others).

6. Start GeneLinker™.

If there are any problems during step 5 (for example, you mistype the name of the database), then GeneLinker™'s configuration will not be changed.

Note that an Oracle GeneLinker™ database cannot be shared by multiple users. Attempting to do so will corrupt the database and cause valuable information to be lost.