Oracle Workflow Server Upgrade
To upgrade an existing version of Oracle Workflow Server Release 2.0.3 or 2.5, perform the following steps. The upgrade should take approximately 45 minutes.
Warning: Before you upgrade your Oracle Workflow server, ensure that there are no users accessing the server; otherwise, locks in the database will prohibit a successful upgrade.
Step 1. Edit the database init.ora parameter file.
Before you upgrade Oracle Workflow, you must enable the time manager process in Oracle8 Advanced Queues by adding the following line to the init.ora parameter file:
AQ_TM_PROCESSES=1
Restart your database to make this change effective.
The time manager process is required by Oracle Workflow to monitor delay events in queues, as in the case of the Oracle Workflow standard Wait activity.
Step 2. Load Oracle Workflow files using the Oracle Universal Installer.
Run the Oracle Universal Installer to copy the Oracle Workflow Server files to your file system. Refer to the Oracle8i Installation Guide for your platform for detailed instructions on running the Oracle Universal Installer.
When running the Oracle Universal Installer, select the product Oracle8i Management and Integration Infrastructure. Then select the Oracle Integration Server installation type. Oracle Workflow is included in this installation type.
Note: When you run the Oracle Universal Installer to install Oracle Workflow Release 2.5.2 on an existing database, the Oracle Universal Installer only copies the Oracle Workflow files to your file system; it does not automatically run those files to perform the installation. You must manually run the installation/upgrade script to complete the upgrade. This precaution helps ensure that any previous installation of Oracle Workflow is upgraded correctly. See also: Oracle Workflow Server Installation.
Step 3. Run the upgrade script.
You can run the script to complete the upgrade of an existing installation of Oracle Workflow in two ways: either as an operating system script or as a Java program.
To run the upgrade script as an operating system script, use the following commands:
On UNIX:
$ORACLE_HOME/wf/install/inst252 <wf_account_name> <wf_password> <wf_home> <sys_password> <system_password> <INSTALL|UPGRADE>
On Windows NT:
\<ORACLE_HOME>\wf\install\inst252.bat <wf_account_name> <wf_password> <wf_home> <sys_password> <system_password> <INSTALL|UPGRADE>
Replace the variables with your parameters as follows:
- <wf_account_name>: The user name of your Oracle Workflow database account. The user name should be OWF_MGR.
- <wf_password>: The password for your Oracle Workflow database account. The password should be OWF_MGR.
- <wf_home>: The Workflow directory within your ORACLE_HOME.
- <sys_password>: Your SYS password. See your Oracle DBA if you need more information.
- <system_password>: Your SYSTEM password. See your Oracle DBA if you need more information.
- <INSTALL|UPGRADE>: The installation type you want to perform. Enter UPGRADE to upgrade an existing installation of Oracle Workflow, or enter INSTALL to perform a fresh installation of Oracle Workflow.
To run the upgrade script as a Java program, use the following commands:
On UNIX:
$ORACLE_HOME/wf/install/inst252j
On Windows NT:
\<ORACLE_HOME>\wf\install\inst252j.bat
The script prompts you to enter the installation type you want to perform. Enter UPGRADE to upgrade an existing installation of Oracle Workflow, or enter INSTALL to perform a fresh installation of Oracle Workflow.
Note: If you want to perform a fresh installation of Oracle Workflow, enter INSTALL as the installation type and follow the instructions to perform a fresh installation. See: Oracle Workflow Server Installation.
Step 4. Verify your directory service data model.
Run the script wfdirchk.sql in SQL*PLUS to verify the integrity of your directory service data model. The script is located on your Oracle Workflow server in the Oracle Workflow admin\sql subdirectory. Refer to the Workflow Administration Scripts chapter of the Oracle Workflow Guide for more information.
Step 5. Set up the Oracle Workflow Monitor and HTML Help.
Before you can use the Oracle Workflow Monitor and the Oracle Workflow HTML help, you must extract the help files and add some virtual directory mappings to your web listener. Refer to the following instructions to perform the appropriate installation steps:
