Information

Pathway Tools Overview Pathway Tools Testimonials
Publications
Release Note History
Contributions
Pathway Tools Blog
Technical Datasheet
Fact Sheet
Pathway Tools Testimonials
Contact Us

Licensing

Academic Licenses Commercial Licenses

Technical Specs

Web Services
Pathway Tools APIs
Installation Guide
Ontologies
Operations
File Formats

Support

Submitting Bug Reports
Tutorials
FAQs
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.