Installing Oracle Workflow 2.6.4 (Oracle 10g) on SLES 10.0

Previous Posts:
Oracle 10g Rel 2 on SLES 10.0
Installation Prepation
Hardware and Software check
Software Installation
Patch Oracle Database Software
Create Database
Install Oracle HTTP Server
Install APEX
Install BI Publisher
Automate Startup/Shutdown

In this post I will try to describe the Installation of Oracle Workflow 2.6.4 (OWF or WF) on SuSE Linux Enterprise Server 10.0 (SLES).

Downloads
The Installation Software:
Oracle Database 10g Companion CD Release 2 (10.2.0.1.0) for Linux x86
Installation Documentation:
Companion CD Installation Guide for Linux x86

To install OWF You must have installed the Oracle Software, created the Oracle Database and Installed the Oracle HTTP Server. This steps are described in previous posts:
Hardware and Software check
Software Installation
Patch Oracle Database Software
Create Database
Install Oracle HTTP Server

First check if You have SLES 10.0 installed with OpenMotif. To do this connect to Your Linux Box as user "root".
vl094:~ # rpm -q openmotif openmotif-2.2.4-21.2

You can find and install the rpm-packages with OpenMotif on SLES 10.0 distribution media:


Make the "oraInventory" log directory writable for the group "oinstall":
vl094:~ # chmod 770 /appl/oracle/oraInventory/logs

The downloaded ZIP file 10201_companion_linux32.zip is unziped in /appl/home/orahs/companion.

Install Oracle Workflow Server
First we have to install Oracle Workflow Server as user oracle (Unix owner of Oracle Database Software).
Connect to Linux Box as user Oracle

vl094:~ # ssh -Xl oracle vl094
Password:
Last login: Wed Oct 3 23:38:30 2007 from vl094.fla.net
oracle@vl094:~>

With xclock check if the X-server configuration is OK.
Check the DB configurations parameter:
job_queue_processes, must be at least 10 and
aq_tm_processes must be at least 2.

oracle@vl094:~> sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 1 21:16:16 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter job

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
SQL> show parameter aq_

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
SQL> alter system set aq_tm_processes=2 scope=both;

System altered.

SQL>

Start Installer:

oracle@vl094:~> ../orahs/companion/runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-10-01_08-21-09PM. Please wait ...oracle@vl094:~> Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved

.Form : WelcomePress: Next
--------------------------
Form: Select a Product to Install
Select second option: Oracle Database 10g Products 10.2.0.1.
Press: Next
--------------------------
Form: Specify Home Details
For Destination enter:
Name: OraDb10g_home1
Path: /appl/oracle/product/10.2.0.0/db_1
Press: Next
--------------------------
Form: Product-Specific Prerequiste Checks
Press: Next
--------------------------
Form: Summary
Press: Install
--------------------------
Form: Install
Wait until Installation finished.
Press: Next
--------------------------
Form: End of Installation
Press: Exit
--------------------------
Form: Exit
Press: Yes

Now I have configured and installed the Oracle Worflow in the Database using Oracle Workfow Configuration Assistant:

oracle@vl094:~> /appl/oracle/product/10.2.0/db_1/wf/install/wfinstall.csh
Workflow Configuration Assistant - Linux
4
Parameter "wfdir" = /appl/oracle/product/10.2.0/db_1/wf
Parameter "orahome" = /appl/oracle/product/10.2.0/db_1
WorkflowCA: /appl/oracle/product/10.2.0/db_1/wf/install/workflow.log
WorkflowCA:
WorkflowCA: Workflow Configuration in progress...
WorkflowCA: Mon Oct 01 21:18:25 CEST 2007
WorkflowCA:
WorkflowCA: Screen width -1024-, screen height -768-
WorkflowCA:
WorkflowCA: Graphics User Interface mode
WorkflowCA:
WorkflowCA:

Form: Oracle Workflow Configuration Assistant

Enter following information:
Install Option: Server Only
Workflow Account: owf_mgr
Workflow Password: qwertz
SYS Password: qwertz
TNS Connect Descriptor: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vl094.fla.net)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DB094.fla.net)))
Leave other selections empty and Language Selection must be set to US.
Press: Submit
--------------------
Form: Workflow Configuration Assistant
Press: OK

Now I have added the German language to Oracle Workflow.

oracle@vl094:~> /appl/oracle/product/10.2.0/db_1/wf/install/wfinstall.csh
Workflow Configuration Assistant - Linux
4
Parameter "wfdir" = /appl/oracle/product/10.2.0/db_1/wf
Parameter "orahome" = /appl/oracle/product/10.2.0/db_1
WorkflowCA: /appl/oracle/product/10.2.0/db_1/wf/install/workflow.log
WorkflowCA:
WorkflowCA: Workflow Configuration in progress...
WorkflowCA: Mon Oct 01 21:18:25 CEST 2007
WorkflowCA:
WorkflowCA: Screen width -1024-, screen height -768-
WorkflowCA:
WorkflowCA: Graphics User Interface mode
WorkflowCA:
WorkflowCA:

Form: Oracle Workflow Configuration Assistant

Enter following information:
Install Option: Add Language
Workflow Account: owf_mgr
Workflow Password: qwertz
SYS Password: qwertz
TNS Connect Descriptor: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vl094.fla.net)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DB094.fla.net)))
Language Selection: D
Press: Submit.
------------------------------
Form: Workflow Configuration Assistant
Press: OK.

Install Oracle Workflow middle-tier components.
Press: OK.
The Installation of Oracle Workflow middle-tier components is executed from Linux User orahs - owner of Oracle HTTP Server software installation.

vl094:~ # ssh -Xl orahs vl094
Password:
Last login: Sun Sep 30 00:09:17 2007 from vl094.fla.net
orahs@vl094:~> export DISPLAY=:0.0
orahs@vl094:~> xclock
orahs@vl094:~>

vl094:~ # chmod 770 /appl/oracle/oraInventory/logs/

orahs@vl094:~> ./companion/runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-10-01_08-51-33PM. Please wait ...orahs@vl094:~> Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.

Form: Welcome
Press: Next
--------------------------
Form: Select a Product to Install
Select: Oracle 10g Companion Products 10.2.0.1.0
Press: Next
--------------------------
Form: Specify Home Details
Enter following informations:
Name: OraDb10g_home
Path: /appl/orahs/product/10.2.0/db_1
Press: Next
--------------------------
Form: Available product Components
Select Oracle Workflow Middle Tier 2.6.4.0.0
Press: Next
--------------------------
form: Product-Specific prerequiste Check
In this Oracle Home is installed Oracle HTTP Server. This two products is allowed to install in the same Oracle Home.
Select Checking for Oracle Home incompatibilities - so I ignored this recommendation.
Press: Next
--------------------------
Form: Oracle Workflow Middle Tier Configration
Enter following mandatory Informations:
Workflow Schema: OWF_MGR
DB Hostname: vl094.fla.net
Port Number: 1521
Oracle SID: DB094
Press: Next
--------------------------
Form: Oracle Workflow Middle Tier Configuration
Enter Password for OWF_MGR: qwertz
Press: Next
--------------------------
Form: Summary
Press: Install
--------------------------
Form: Install

Wait until all components installed.
--------------------------
Form End of Installation
Press: Exit
----------------------------
Form: Exit
Press: Yes

After this Installation I compiled the invalid Object. You must be connected to Linux Box as user oracle and to the database as user SYS.
Start sqlplus and execute the SQL script: @?/rdbms/admin/utlrp.sql
Using unzip Linux utility unzip extract the "doc" directory from $ORACLE_HOME/wf/wfdoc.zip.
We will need this file for Oracle Workflow HTML Help.

oracle@vl094:/appl/oracle/product/10.2.0/db_1/wf> unzip wfdoc.zip
Archive: wfdoc.zip
replace doc/US/wf/accmon.htm? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
inflating: doc/US/wf/accmon.htm
replace doc/US/wf/accmon01.htm? [y]es, [n]o, [A]ll, [N]one, [r]ename: A

To start Oracle Workflow use:
oracle@vl094:~> /appl/oracle/product/10.2.0/db_1/wf/admin/wfmgrstart.csh
To stop Oracle Workflow use:
oracle@vl094:~> /appl/oracle/product/10.2.0/db_1/wf/admin/wfmgrstop.csh

Try to connect with Oracle Workflow Manager: http://vl094.fla.net:7780/pls/wf/wfa_html.home

The Oracle Workflow - Server and Middle Tier - are installed!

Regards,
Flavio