Information

Pathway Tools Overview
Academic Download

Publications
Release Note History
Contributions
Pathway Tools Blog
Technical Datasheet
Contact Us

Technical Specs

Web Services
Pathway Tools APIs
Installation Guide
Ontologies
Operations
File Formats

Support

Submitting Bug Reports
Tutorials
User Forum / FAQ
User Group Meetings
Webinars

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.