Activity:          Oracle Workflow Server Installation without integration with Oracle Internet Directory (OID).

Database: Oracle       Version: 10.2.0.1         Operational System: Linux     Version: Red Hat 4

Author: Andrea Rodacki - IBM                                                             Date: 12/30/2005

Reviser:  Marco Túlio de Siqueira Campos - GVS                                         Date: 12/31/2005

HARDWARE AND SOFTWARE REQUIREMENTS

·         Oracle Database 10g, along with the Oracle Objects and Oracle JVM options, installed on a supported server machine.

·         At least 65 Mb of available disk space for Oracle Workflow server components once they are installed in your Oracle home.

·         Oracle HTTP Server installed in a middle tier Oracle home. Your Oracle HTTP Server installation must be able to access the Oracle Workflow Java area, the Oracle Workflow icon area, and the Oracle Workflow documentation area.

·         At least 2 Mb of available disk space for Oracle Workflow middle tier components once they are installed in your Oracle home.

·         A Web browser that supports frames, JavaScript, Java Development Kit (JDK) Version 1.3.1, and AWT, such as Netscape Communicator version 4.76 or a higher 4.7x version, or Microsoft Internet Explorer version 5.0x or 5.5x.

·         Java Development Kit (JDK) Version 1.4, to run the Oracle Workflow Java Function Activity Agent and the Workflow XML Loader.

CAUTION

·         To upgrade to Release 2.6.3, your existing Oracle Workflow Server must be Release 2.6.0 or higher. If you have an earlier version of Oracle Workflow, you must upgrade Oracle Workflow to Release 2.6.

·         Before you upgrade an existing Oracle Workflow server, ensure that there are no users accessing the server. Otherwise, locks in the database will prohibit a successful upgrade.

INSTALLATION

Step 1. Set the database initialization parameters.

You must verify the following parameters set in the database initialization parameter file or server parameter file:

·         AQ_TM_PROCESSES - Oracle Workflow requires the time manager process in Oracle Streams Advanced Queuing (AQ) to monitor delay events in queues, as in the case of the Oracle Workflow standard Wait activity. The recommended number of time manager processes for Oracle Workflow is one or more. Verify that the AQ_TM_PROCESSES parameter is set appropriately. For example:

AQ_TM_PROCESSES = 2

·         JOB_QUEUE_PROCESSES - Oracle Workflow leverages Oracle Streams Advanced Queuing, which requires job queue processes to handle message propagation. You must start at least one job queue process to enable message propagation. The minimum recommended number of processes for Oracle Workflow is ten and may need to be increased if not enough processes are available for propagation. Verify that the JOB_QUEUE_PROCESSES parameter is set to specify the number of SNP job queue processes for your instance. For example:

JOB_QUEUE_PROCESSES = 10

Step 2. Install Oracle Workflow Server files using the Oracle Universal Installer.

Run the Oracle Universal Installer from the Oracle Workflow Server CD to copy the Oracle Workflow Server files to your file system.

Note:   Before you begin running the Oracle Universal Installer, you should close other applications you may have running, including Java applications, Oracle-based applications, and any other applications that consume large amounts of memory, hard disk space, or CPU time. However, you should not close any components of the Oracle Database where you want to install Oracle Workflow.

In the Oracle Universal Installer, choose to install into the Oracle home for your Oracle Database 10g, and select Oracle Workflow Server as the component to install.

To complete the installation, follow the instructions displayed in the Oracle Universal Installer screens. If you need additional information about any screen, click Help. When the installation completes, click Exit and click Yes to exit from the Oracle Universal Installer.

Command: ./runInstaller

Step 3. Run the Workflow Configuration Assistant.

Run the Workflow Configuration Assistant from your database Oracle home to load Oracle Workflow into your database.

1.Start the Workflow Configuration Assistant

$ORACLE_HOME/wf/install/wfinstall.csh

2.In the Oracle Workflow Configuration Assistant window, enter the following user information:

o     Workflow Account - The user name of your Oracle Workflow database account. The default Workflow account for a fresh installation is owf_mgr.

o     Workflow Password - The password for your Oracle Workflow database account.

Note: If you are performing a fresh installation of Oracle Workflow, the Workflow Configuration Assistant creates a new database account for Oracle Workflow with the user name and password you specify. The default tablespace for this account defaults to USERS, and the temporary tablespace defaults to TEMP. You can change the tablespace if necessary.

If you are upgrading an existing installation of Oracle Workflow, you should enter the user name and password for your existing Oracle Workflow database account.

o     SYS Password - Your SYS password. See your Oracle DBA if you need more information.

o     Install Option - Select Install to perform a fresh installation of Oracle Workflow, Upgrade to upgrade an existing installation of Oracle Workflow, or Add language to load a language into your existing installation of Oracle Workflow.

If you choose the Install or Upgrade options, the Workflow Configuration Assistant loads Oracle Workflow into your database and configures the Oracle Workflow Manager component of Oracle Enterprise Manager.

If you select the Install option, but you are installing into a database where there is already an existing installation of Oracle Workflow Server Release 2.6.0 or higher, then the Oracle Workflow Configuration Assistant will switch to Upgrade mode to upgrade the existing Oracle Workflow Server installation to Release 2.6.3

o     Language Selection - If you chose the Add Language install option, select the language abbreviation for the language you want to add. Oracle Workflow Server supports the languages supported by the Oracle Database: Arabic (AR), Brazilian Portuguese (PTB), Czech (CS), Danish (DK), Dutch (NL), English (US), Finnish (SF), French (F), German (D), Greek (EL), Hebrew (IW), Hungarian (HU), Italian (I), Japanese (JA), Korean (KO), Norwegian (N), Polish (PL), Portuguese (PT), Romanian (RO), Russian (RU), Simplified Chinese (ZHS), Slovak (SK), Spanish (E), Swedish (S), Thai (TH), Traditional Chinese (ZHT), and Turkish (TR).

o     Connect Method - Select Local to connect to a local database using the Oracle SID, or select Remote to connect to a remote database through Oracle Net using LOCAL on Windows or TWO_TASK on UNIX.

o     Connect String - If you choose the Remote connect method, enter the connect string for the remote database (<service_name>).

o     Host Name - The host on which your Oracle Database is installed.

o     JDBC Connection: The JDBC connect string, including the host name, port number, and database system identifier (SID) in the following format:

<host_name>:<port_number>:<ORACLE_SID>

Step 4. Access Oracle Workflow Manager.

The Oracle Workflow server installation also includes the Oracle Workflow Manager component of Oracle Enterprise Manager, which provides administrative and management tools for Oracle Workflow. When you install Oracle Workflow into your Oracle Database home, the Workflow Configuration Assistant configures Oracle Workflow Manager. It creates two new Oracle Application Server Containers for Java 2 Enterprise Edition (OC4J) instances:

·         OC4J_Workflow_Component_Container - The Workflow Configuration Assistant deploys two applications within this instance, one to run agent listener service components and one to run notification mailer service components.

·         OC4J_Workflow_Management_Container - The Workflow Configuration Assistant deploys one application within this instance to implement the Oracle Workflow Manager user interface.

To access the Oracle Workflow Manager user interface, perform the following steps.

1.Start the OC4J_Workflow_Component_Container instance using the following command:

$ORACLE_HOME/jdk/bin/java -Djava.security.properties=$ORACLE_HOME/oc4j/j2ee/home/config/jazn.security.props -jar $ORACLE_HOME/oc4j/j2ee/home/oc4j.jar -userThreads -config $ORACLE_HOME/oc4j/j2ee/OC4J_Workflow_Component_Container/config/server.xml &

2.Start the OC4J_Workflow_Management_Container instance using the following command:

$ORACLE_HOME/jdk/bin/java -Djava.security.properties=$ORACLE_HOME/oc4j/j2ee/home/config/jazn.security.props -jar $ORACLE_HOME/oc4j/j2ee/home/oc4j.jar  -config $ORACLE_HOME/oc4j/j2ee/OC4J_Workflow_Management_Container/config/server.xml &

3.Navigate to the following URL:

http://<host_name>:<port_number>/WFMGRWebApp/uix/oam/wfm/wfmLogin

where <host_name> represents the host server where OC4J is installed and <port_number> represents the http port specified in the $ORACLE_HOME/oc4j/j2ee/OC4J_Workflow_Management_Container/config/http-web-site.xml configuration file.

Log in using your Oracle Workflow database username and password and the connect string for the database where Oracle Workflow is installed. Specify the connect string, including the host name, port number, and database system identifier (SID), in the following format:

<host_name>:<port_number>:<ORACLE_SID>

You can stop and restart the OC4J instances in which Oracle Workflow Manager is deployed if necessary. To stop an OC4J instance, use the following command:

${ORACLE_HOME}/jdk/bin/java -jar ${ORACLE_HOME}/oc4j/j2ee/home/admin.jar ormi://<host_name>:<RMI_port> admin welcome -shutdown

where <host_name> and <RMI_port> represent the host server and remote method invocation (RMI) port for the instance that you want to stop, as listed in the rmi.xml configuration file for the instance.

·         OC4J_Workflow_Management_Container - The configuration file is located at:

$ORACLE_HOME/oc4j/j2ee/OC4J_Workflow_Management_Container/config/rmi.xml

·         OC4J_Workflow_Component_Container - The configuration file is located at:

$ORACLE_HOME/oc4j/j2ee/OC4J_Workflow_Component_Container/config/rmi.xml