Installation of Oracle WebDB for Oracle Workflow Option
Step 1. Install Oracle WebDB 2.0 or higher components.
1. Perform a custom installation of Oracle WebDB and install the following components:
- PL/SQL Web Toolkit Version 4.0.5.4.0 or higher
- WebDB Listener Version 2.0.3.1.3 or higher
Note: You do not need to install the WebDB component.
Refer to your Oracle WebDB installation documentation for further details.
2. A WebDB Listener dialog box appears during the installation procedure. Enter the following information in the dialog box:
- Host Name--enter the name of the server on which your web listener accepts requests.
- Database Access Descriptor Name--accept the default value. This is the DAD name for your WebDB installation, but since you are not installing the WebDB component, do not worry about this value.
- WebDB User Name--accept the default value. This is the name of the database schema in which Oracle WebDB will be installed, but since you are not installing the WebDB component, you do not need to change this value.
- Port #--the TCP/IP port number on which your listener accepts requests.
3. Complete the installation procedure as described in your Oracle WebDB documentation.
Once the installation procedure finishes, a confirmation dialog box displays two URLs to which you can navigate to make modifications to your WebDB configuration. The URLs are:
http://<server_name>[:<portID>]/<DAD>/admin_/gateway.htm
http://<server_name>[:<portID>]/<DAD>/admin_/listener.htm
The http://<server_name>[:<portID>]/ portion of these URLs is called the base URL for your listener, where <server_name> and <portID> represent the server and TCP/IP port number on which your web listener accepts requests. For example:
http://prod.company.com/
http://test.company.com:8000/
Step 2. Create a DAD for the Oracle Workflow schema.
1. Using your web browser, navigate to the Oracle WebDB PL/SQL Gateway Settings page:
http://<server_name>[:<portID>]/<DAD>/admin_/gateway.htm
2. Create a DAD for Oracle Workflow by entering the information shown below. Make sure you create a new DAD and do not modify the existing default "WebDB" DAD.
Database Access Descriptor Name <WF_DAD>
Oracle User Name <Leave Blank>
Oracle Password <Leave Blank>
Oracle Connect String <CONNECT_STRING>
Maximum Number of Worker Threads 4
Keep Database Connection Open between
Requests? Yes
Default (Home) Page wfa_html.home
Document Table <WF_account>.wwv_document
Document Access Path docs
Document Access Procedure <WF_account>.wwv_testdoc.process_download
Attention: Be sure you leave the Oracle User Name and Oracle Password null to enable WebDB database authentication.
Attention: If you wish to set up a demonstration or test environment that has no Webdb database authentication, you can enter your Oracle Workflow account username and password in the Oracle User Name and Oracle Password fields and enter wfa_html.login for the Default (Home) Page field. When you navigate to the base URL of your listener, the Oracle Workflow login page appears; in this page you can enter any user name and password to display the Oracle Workflow home page. Please be aware that you should not use this configuration in a production environment as it provides no username/password validation.
