Information

Licensing

Technical Specs

Support

Instructions for Setting up an Oracle Database for Pathway Tools

The Pathway Tools have been tested with Oracle versions 7.3.2 through 8.1.5. This document does not cover details on how to install Oracle or set up clients to access Oracle. Consult the Oracle Server Administrator's Guide for such information.

In order to use the Pathway Tools with Oracle, the database administrator will need to do the following:

Create a database with ORACLE_SID = PERK, and create tablespaces, datafiles, etc. Allocate roughly 500M for datafiles (at the present time, this is an overestimate of how much space you will need).
Create a user ECOCYC with password ECOCYC. Grant this user connect and resource privileges.
Connect to PERK using sqlplus and run the file aic-export/pathway-tools/[version]/sql/build-perk.sql. This will create the schema tables and indexes.