My Oracle Support Banner

How To Restart DMW/LSH 2.5.1 And Prior Versions Successfully (Doc ID 2250628.1)

Last updated on JULY 20, 2020

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.6 to 2.5.1 [Release 2.4 to 2.5.0]
Oracle Life Sciences Data Hub - Version 2.4.6 to 2.5.1 [Release 2.4 to 2.5.0]
Information in this document applies to any platform.

Goal

How to restart LSW services successfully?

Note: This MOS Document is applicable only for LSH/DMW Versions starting from 2.4 up to version 2.5.1. Please refer to Doc ID 2689508.1 for LSH/DMW 2.5.2 and later versions.

There is no single command to startup LSW. It includes different processes/services with dependencies between them. If they are not stopped/started in the correct order, you may hit unexpected issues later, i.e., defunct processes alive in memory that may not permit the new/fresh ones are started up successfully, or services starting up with incorrect values/environment settings.

The technical details shared in this document are from LSH Administrator's Guide "Stopping and Starting Services and Queues" and DMW Installation Guide, i.e., DMW Release 2.4 information is in Chapter 3.12 Restart the WebLogic Server.

In summary, you need to apply below order to accomplish a successful restart:

These KM NOTE steps only apply when you are doing shutting down activity explicitly.

 

To Shutdown LSW:

1.  Stop Job Queue/Message Queue  and Confirm queues are not running
2.  Stop Middle Tiers (DMW first then LSH)
3.  Confirm there are no jobs in EXECUTING status in the system

4.  Stop OWB services (CRITICAL: Make sure you wait 10 minutes before starting up OWB services)
5.  Stop DP Servers

6. Purge OWB Execution Audit Tables
7. Shutdown the TNS listener and the DB

To start up LSW, you practically apply the reverse order:

8. Start the DB and then, the TNS listener (CRITICAL: Make sure you wait 10 minutes before doing next step -> starting up OWB services)
9. Start OWB Services
10. Start DP Servers
11. Start Middle Tiers (LSH first then DMW)
12. Start Job Queue/Message Queue and confirm queues are up and running

This document explains above with step by step generic instructions, but feel free to create your custom shell script(s) if it facilitates this task. 

 


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Shut Down LSW
 1. Stop Job Queue/Message Queue and Confirm queues are not running
 2.  Stop Middle Tiers (DMW first then LSH)
 2b. Restrict scheduled run during downtime
 3. Confirm there are no jobs in EXECUTING status in the system
 4.  Stop OWB services
 5.  Stop DP Servers
 6. Purge OWB Execution Audit Tables
 7. Shutdown the TNS listener and the DB
  
 Start Up LSW
 8.  Start the TNS listener and the DB
 9. Start OWB Services
 10. Start DP Servers
 11. Start Middle Tiers (LSH first then DMW)
 12. Start Job Queue/Message Queue and confirm queues are up and running
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.