WorkflowGen v5: What are the installation requirements for an Oracle 10g setup with WorkflowGen?

Administration Database
1

For WorkflowGen version 5.x only

Issue

What are the installation requirements for an Oracle setup with WorkflowGen?

Description

There are 2 possible scenarios when installing WorkflowGen on an Oracle 10g database: 

  1. WorkflowGen and Oracle are on the same server
  2. WorkflowGen and Oracle are on separate servers 

Requirements

Case 1:

  1. National and Database Character Sets are both UTF8
  2. Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4) Standard
  3. .NET Framework 2.0, 3.0, 3.5 SP1
  4. WorkflowGen 5.1.6

Case 2:

  1. National and Database Character Sets are both UTF8
  2. Oracle machine has Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4) Standard
  3. WorkflowGen machine has:
    1. Oracle Database 10g Client Release 2 (10.2.0.3)
    2. .NET Framework 2.0, 3.0, 3.5 SP1
    3. WorkflowGen 5.1.6

Reference

Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4)
http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip

Oracle Database 10g Client Release 2 (10.2.0.3)
http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_client.zip