9 Upgrading to Release 2.4

To upgrade Oracle Health Sciences Data Management Workbench (Oracle DMW) from Release 2.3.1 to Release 2.4, follow instructions in this chapter.

9.1 Upgrade Oracle Life Sciences Data Hub

Follow instructions in the Oracle Life Sciences Data Hub Installation Guide chapter on upgrading to Release 2.4. The process includes upgrading Oracle Database.

9.2 Install the Latest Version of JDK

Follow instructions in Section 3.1, "Install Oracle Java Development Kit" to install JDK 1.7.0_51 or higher.

9.3 Apply WLS Patch 10.3.6.0.8

Install Oracle WebLogic Server Patch Set Update (PSU) 10.3.6.0.8, which is patch 18040640, following instructions in the readme file. See "Finding Patches on My Oracle Support."

9.4 Enable WLS Policy Manager

9.4.1 Create the Metadata Services Repository Schema in the Database

See Section 3.4, "Create the Metadata Services Repository Schema in the Database."

9.4.2 Extend Your WebLogic Server Domain

Extend your WLS domain (suggested name DMWDomain) to add these settings. Instruction for extending domains are included in Creating Domains Using the Configuration Wizard at http://docs.oracle.com/cd/E23943_01/web.1111/e14140.pdf.

Oracle WSM Policy Manager - 11.1.1.0 [oracle_common]
For the JDBC Component Schema, specify the Metadata Services Schema you created in "Create the Metadata Services Repository Schema in the Database."
Specify that the JDBC services mds-owsm and wsm-pm are deployed to the AdminServer or the managed server where you want the WSM service to be running.

9.4.3 Support SSL Wildcards and SSL Web Services

See Section 3.5.6, "Support SSL Wildcards and SSL Web Services."

9.5 Edit setDomainEnv.sh

Even if you already edited setDomainEnv.sh for a previous release, additional changes are required for Release 2.4. Follow instructions in Section 3.8, "Edit setDomainEnv.sh."

9.6 Restart the WebLogic Server

See Section 3.16, "Restart the WebLogic Server."

9.7 Deploy Oracle DMW to the WebLogic Server

You must deploy the new version of Oracle DMW to the WebLogic Server. Follow instructions in Section 4, "Deploy Oracle DMW on the WebLogic Server," including instructions for applying the latest patch set and patches.

9.8 Update InForm Setup

The InForm setup files have been updated for Release 2.4. To apply the changes:

Follow instructions in Section 5.3.2, "Copy Scripts".
Follow instructions in Section 5.3.3, "Run the Driver Script".

When prompted for an Admin account, enter an existing account. Confirm that you want to upgrade.

When prompted for a DMW Read-Only account, enter an existing account. Confirm that you want to upgrade.

9.9 Upgrade File Watcher to Support Archiving Files (Optional)

File Watcher now supports automatically archiving loaded data files. To archive loaded files, you must set up the folders in which to store them the same way you do the folders where you put files to be loaded: create a specified directory structure and register the path for each as Oracle LSH profile values.

To archive files in an existing, pre-Release 2.4 study, edit the study File Watcher and click the Regenerate button to enable archiving for the study.

See the Oracle Health Sciences Data Management Workbench User's Guide for more information.

9.10 Install Oracle Thesaurus Management System (Optional)

If you plan to use Oracle Thesaurus Management System (TMS) as a coding tool integrated with Oracle DMW, follow instructions in Chapter 7, "Installing Oracle Thesaurus Management System (Optional)."