TekPortal V3.00.011
Copyright (c) 2000-2004.  Teknowledge Corporation.  All Rights Reserved.

5/28/2004


Overview
- TPClient2
  - ISSUE: Add support for multiple hardcoded IP addresses in configuration
    RESOLUTION: Enhancement
- Database
  - ISSUE: Add sample configuration for Oracle OCI8 (thick) client
    RESOLUTION: Enhancement


Requirements
- TekPortal V3.0 Patch 010
                    

Installation Instructions
- Log on to each of the TekPortal Aggregation Server(s) and TekPortfolio
  Application Server(s)
- Solaris
  - Login as tekp
  - Bring down TekPortal with TekPortal/bin/StopServices.sh
  - uncompress -c TekPortal_V3.00.011.tar.Z | (cd /; tar -xvf -)
  - chown -R tekp:tekp /TekPortal/*
  - chmod -R 750 /TekPortal/*
  - Bring up TekPortal with TekPortal/bin/StartServices.sh
- Windows NT/2000
  - Bring down TekPortal with c:\TekPortal\bin\StopServices.cmd
  - Run TekPortal_V3.00.011.exe and extract to c:\
  - Bring up TekPortal with c:\TekPortal\bin\StartServices.cmd
- SPECIAL INSTRUCTIONS
  - This update requires an additional database view added.  Please follow
    the instructions below for the database you use.
    - Microsoft SQL Server:
      - Open SQL Query Analyzer
      - Select user TekPortal
      - Select your database (e.g. TekPortal3)
      - Verify you're in the right database by running the following SQL and 
        getting a non-zero value:
          SELECT COUNT(*) FROM TP_INSTITUTION;
      - CREATE VIEW TekPortal.TP_PARTNER_INSTITUTION_VIEW AS
          SELECT TekPortal.TP_PARTNER_INSTITUTION.*
          FROM TekPortal.TP_PARTNER_INSTITUTION
    - Oracle
      - Logon to your database server
      - sqlplus (w/user TekPortal)
      - Verify you're in the right database by running the following SQL and 
        getting a non-zero value:
          SELECT COUNT(*) FROM TP_INSTITUTION;
      - CREATE VIEW TP_PARTNER_INSTITUTION_VIEW AS
          SELECT TP_PARTNER_INSTITUTION.*
          FROM TP_PARTNER_INSTITUTION;
    - PostgreSQL
      - Logon to your database server
      - psql TEKP3 -U TekPortal
      - set searchpath to TekPortal
      - Verify you're in the right database by running the following SQL and 
        getting a non-zero value:
          SELECT COUNT(*) FROM TP_INSTITUTION;
      - CREATE VIEW TP_PARTNER_INSTITUTION_VIEW AS
          SELECT TP_PARTNER_INSTITUTION.* FROM TP_PARTNER_INSTITUTION;


Summary of Changes
- Note: The following are the specific files that have changed.  If you have
  made any custom modifications to these files, you will need to reapply
  those changes to these new versions; or else these versions will overwrite
  your custom modifications.
- TPClient2.jar
  - ISSUE: Add support for multiple hardcoded IP addresses in configuration
    RESOLUTION: Enhancement
- Customer.SAMPLE.cfg
  - ISSUE: Add sample configuration for Oracle OCI8 (thick) client
    RESOLUTION: Enhancement