Install Oracle Workflow Server

Introduction:

Oracle Workflow stages the OWB Process Flows.

Aim:

Install and configure Oracle Workflow Server.

Requirements:

Oracle is installed and running on the server.

Procedure:

• Log on to Linux as Oracle.
• Open Firefox.
  
• Get the software:
• Go here (OTN - link through here to register), promise that you're not a terrorist, and download the following file:
• 10201_companion_linux32.zip
  
• Load the software:
• Open Terminal.
• $ mkdir orawf
• $ cd orawf
• $ unzip 10201_companion_linux32.zip
• This creates the directory; companion. Probably a good idea to burn the contents of this directory to CD now.
• $ cd companion
  
• $ ./runInstaller
• Welcome:
• [Next]
• Select a Product to Install:
• Oracle Database 10g Products 10.2.0.1.0
• [Next]
  
• Specify Home Details:
• Name: OraDb10g_home1
• Path: /u01/app/oracle/10.2.0.1/db01
• [Next]
  
• Product-Specific Prerequisite Checks:
• [Next]
• Summary:
• [Install]
• End of Installation:
• Two URLs are listed. Make a note of these.
• [Exit]
• Exit:
• [Yes]
• Install the software for the instance whs:
• In OEM Console:
• Expand instance -> Instance
• -Configuration-
• General tab:
• [All Initialisation Parameters]
• Ensure the following parameters:
• aq_tm_processes: 2
• joq_queue_processes: 10
• [Apply]
• In Terminal:
• $ cd $ORACLE_HOME/wf/install
• $ export ORACLE_SID=whs
  
• $ ./wfinstall.csh
• Oracle Workflow Configuration Assistant:
• Install Option: -Server Only-
  
• Workflow Account: owf_mgr
• Workflow Password: *********
  
• SYS Password: *********
• TNS Connect Descriptor: lisa:1521:whs
• [Submit]
• Popup: [OK]
• In OEM Console:
• Add the following privileges to the OWF_MGR user:
• CREATE DATABASE LINK
• EXECUTE ANY PROCEDURE
  

Testing:

Extensive testing will be done when there are process flows to deploy.