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
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.