X

Welcome to All Things Warehouse Builder

  • October 13, 2010

OWB 11gR2 Tip: Downloading and Installing Workflow Monitor 2.6.4

Guest Author

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à!

Join the discussion

Comments ( 6 )
  • Dan Monday, June 3, 2013

    Hello.

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

    Thanks.

    Dan


  • David Tuesday, June 4, 2013

    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


  • Dan Tuesday, June 4, 2013

    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


  • guest Wednesday, August 21, 2013

    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


  • Tonny de Groot Thursday, July 17, 2014

    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>


  • David Wednesday, July 23, 2014

    Hi Tonny

    Thanks for providing updates, that will help others!

    Cheers

    David


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.