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
Pathway Tools Installation Guide -- Upgrading from Oracle 8 to Oracle 10

Pathway Tools Installation Guide -- Upgrading from Oracle 8 to Oracle 10

Pathway Tools Solaris versions from 6.0 to 9.0 have worked with Oracle 8. The current version, Pathway Tools 9.5, does not, so if you've been using Pathway Tools with Oracle 8, you need to upgrade to Oracle 10. (We haven't tried Oracle 9.) An experienced Oracle database administrator should upgrade your data from Oracle 8 to Oracle 10. Here are the other requirements when upgrading:
  • We suggest you backup the Perk database before upgrading in case something goes wrong during upgrading.
  • The default database name has changed from perk to biocyc.
  • The default username and password have changed from ecocyc to biocyc.
  • The following new column definitions are required:
        ALTER TABLE txntable
        ADD (
          txn_comment VARCHAR(500),
          app_version VARCHAR(100)
          );
        
  • Leading and trailing quotation marks need to be removed from one of the columns by running the following SQL statement after all data has been imported to Oracle 10:
    update char_slot_values set slotvalue = substr(slotvalue, 2, length(slotvalue) -2) where slotvalue like '"%"';
  • All users should be logged off during the upgrade.
Further information about setting up Oracle 10 is here.