How to install Oracle workflow standalone

The main purpose of this post is how to install oracle standalone workflow repository

Prerequisites

• Download the Companion CD on OTN : Oracle Database 10g Release 2 (10.2.0.1.0) , File : 10201_companion_win32.zip
• Database 10g Installed
  

Steps to install oracle workflow

1- unzip file of companion CD

2-Run the setup.exe file

3-choose the second choice : Oracle Database 10 Products then click on the next button

4-choose the same location and the same oracle home than the database.

Steps to install Oracle Workflow Manager

1-Start the Oracle Universal Installer (already installed). For instance, from the Menu : Start /   All  Programs        Oracle - OraDb10g_Home1 / Oracle Installation Product / Universal Installer.

2-Click next

3-Locate the products.xml of the companion software. Example :<path of companion CD>\10201_companion_win32\stage\products.xml and click next

4-Choose Oracle Database 10 Companion Products (The third one)

5-Then select the two products

6-In the Home Details, specify a new Home in a new Location.

           Name : OraDb10gCompanion_home1 

           Path : C:\oracle\product\10.2.0\OraDb10gCompanion_home1

7-Enter the Workflow Parameters 

   Workflow Schema : owf_mgr

   DbHostName : 127.0.0.1

   Port : 1521 

   SID : ORCL

8-Then fill the workflow user password

9-After the end of the installation, you are normally able to reach this url :

http://hostname:7777/pls/wf/wfa_html.home

10-open the previous link

11-Enter the oracle workflow user and password

Steps to install Oracle standalone Workflow Repository

1-Stop all running OC4J instances

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

/Worklow Configuration Assistant 

3-Enter the following parameter

Install Options: select Server Only

Workflow Account: workflow Schema Name (default owf_mgr)

Workflow password: workflow Schema password

SYS Password: SYS password

TNS Connect Descriptor: <hostname>:<port>:<SID>

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

Thanks