Installation of the Workflow Server 10g/11g

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

The installation process of the server workflow is the same for the 10g of 11g database.

2 - Installation

2.1 - Prerequisites

To enable integration with Oracle Workflow:

  • Stop all running OC4J instances.
  • Locate Oracle Workflow installation program, at OWB_HOME\owb\wf\install\wfinstall.*.

If you installed Oracle Warehouse Builder 11g on Oracle Database 10g Release 2, separately download the software for Oracle Workflow 2.6.4 and return to this article Installation of Oracle Workflow 2.6.4 for Oracle Database 10gR2

Note that if you use multiple Oracle databases, you must unset the environment variables related to Oracle, such as ORACLE_HOME, ORACLE_SID, ORACLE_PORT, and LD_LIBRARY_PATH.

Advertising

2.2 - Workflow Configuration Assistant (WFCA)

2.2.1 - Start

To install the repository, start the Workflow Configuration Assistant (WFCA).

  • For the 10g Stand Alone Product :

From the windows menu : Start/Oracle - OraDb10g_Home1/Configuration and Migration Tools/Worklow Configuration Assistant

  • For the database 11g on windows, enter the following at the command prompt (Oracle_Home\wf\install):
C:\>cd C:\app\Administrator\product\11.1.0\db_1\owb\wf\install
C:\app\Administrator\product\11.1.0\db_1\owb\wf\install>wfinstall.bat

2.2.2 - Parameters

  • Enter LDAP and Workflow Mailer parameters if required

The configuration process can take several minutes. When the process is complete, the Workflow Configuration Assistant displays a message of completion.

In Dutch :

Advertising

3 - Support

The logs are in this directory :

Oracle_Home\wf\install