OWB 11gR2 Tip: Downloading and Installing Workflow Monitor 2.6.4

Oracle Workflow 2.6.4 is still used as an integral part of Warehouse Builder 11gR2—specifically, to support the use of OWB process flows. However, Workflow Monitor is not part of the OWB 11gR2 installation of Workflow. As a result, many users of OWB 11gR2 want to know where to download Workflow Monitor, and how to install Workflow Monitor to manage the workflow jobs OWB creates.

Workflow Monitor usable with OWB 11gR2 is available from the Oracle Database 10gR2 Companion CD, which you can download from OTN. A detailed installation walkthrough on Windows 32-bit follows. Other platforms should be similar.

After you download and unzip the Companion CD, run Oracle Universal Installer from the CD.

IntroHetero000220

Install the 10gR2 Companion Products.

 

IntroHetero000221

Install these products into a separate Oracle Home. Do not install them into the database home.

IntroHetero000222

From the components, select Oracle Workflow Middle Tier 2.6.4. 

IntroHetero000223

Run through the Prerequisite checks.

IntroHetero000224

For the Middle Tier Configuration, enter the host, port and SID fo your database, and the workflow schema OWF_MGR.

IntroHetero000225

Enter the password for OWF_MGR when prompted.

IntroHetero000226

Review the summary, which should look like the one below.

IntroHetero000227

Click “Install” to start the installation process running:

IntroHetero000228

When the installation completes, the Configuration Assistants will run. Wait until they complete.

IntroHetero000229

When the “End of Installation” dialog appears, Workflow Monitor is installed.

IntroHetero000230

You can check whether the HTTP server is running by visiting http://your-host:7777/ – you should see the Oracle HTTP Server Home Page:

IntroHetero000231

You can then go to the Workflow Monitor home page by visiting http://your-host:7777/pls/wf/wfa_html.home – you should see the login screen:

IntroHetero000233 

Log in as OWF_MGR/password.

IntroHetero000234

Et voilà!

Comments:

Hello.

This companion CD is no longer available on OTN. Is there another location where I can download it?

Thanks.

Dan

Posted by Dan on June 03, 2013 at 08:01 AM PDT #

Hi Dan

Did you see the note on OTN? Oracle Database 10.2 and 11.1 are no longer available for download. The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition.

So it is possible to get it you have to jump through some hoops.

Cheers
David

Posted by David on June 04, 2013 at 11:16 AM PDT #

Hi, David.

I did see the note. I've opened an SR for the FTP, but have had no response yet.

Thanks for the information.

Dan

Posted by Dan on June 04, 2013 at 11:19 AM PDT #

Hello,

I'm trying to install Oracle 11gR2 for Asp.Net 2010. First I tried to connect with Asp.net but I'm getting TNS error says TNS connection not found. Please let me know step by step how to download and connect with the asp.net without TNS error?

Thanks

Posted by guest on August 20, 2013 at 05:17 PM PDT #

Just did this walkthrough today, but the dads also had to be configured.
I did this install not in the oracle home of the 11.2 database but in his own home.

it does work but i missed it in the walktrough.

without this addition it did not work.

My dads looks like this now.

"/oracle/product/10.2.0.1/prod/Apache/modplsql/conf/dads.conf" 28 lines, 1231 characters
# ============================================================================
# mod_plsql DAD Configuration File
# ============================================================================
# 1. Please refer to dads.README for a description of this file
# ============================================================================

# Note: This file should typically be included in your plsql.conf file with
# the "include" directive.

# Hint: You can look at some sample DADs in the dads.README file

# ============================================================================
Alias /OA_JAVA/ "/oracle/product/10.2.0.1/prod/owb/oa_java/"
Alias /OA_MEDIA/ "/oracle/product/11.2.0.4/prod/owb/wf/java/oracle/apps/fnd/wf/icons/"
Alias /OA_DOC/ "/oracle/product/11.2.0.4/prod/owb/wf/doc/"

<Location /pls/owf_puds>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername owf_mgr
PlsqlDatabasePassword would_you_like_to_know
PlsqlDatabaseConnectString 10.111.3.250:1521:puds
PlsqlAuthenticationMode Basic
PlsqlDefaultPage wfa_html.home
</Location>

Posted by Tonny de Groot on July 17, 2014 at 01:39 AM PDT #

Hi Tonny

Thanks for providing updates, that will help others!

Cheers
David

Posted by David on July 23, 2014 at 04:02 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today