Upgrade to Oracle Life Sciences Data Hub 2.5

These steps are required for all upgrade paths.

• Database Tier Preinstallation Steps
  
• Apply the Oracle Warehouse Builder (OWB) Patch
  
• Install Oracle Life Sciences Data Hub 2.5
  
• Change Your FND_Validation_Level Profile
  

Database Tier Preinstallation Steps

This section contains the following topics:

• Stop the Message and Job Queues
  
• Abort the Long-Running Jobs
  
• Cancel the Sessions Holding Locks on Application Objects
  
• Disconnect Blocking Sessions
  

Stop the Message and Job Queues

This procedure describes how to stop the message and job queues. If you need more details, see How to Restart LSW Successfully (DMW/LSH), article 2250628.1, on My Oracle Support.

1. Log in to SQL*Plus as apps.
2. Stop the Oracle LSH message queue:

   begin
   cdr_exe_msg_queues_admin.stop_processing_queues;
   end;
   /

3. Make sure the queue is stopped. View the log:

   select MESSAGE from cdr_msg_queues_log order by log_message_id;

   If the most recent statement is the following, the queue is stopped.

   End Procedure cdr_exe_msg_submission.process_queues() 

   If not, stop the queue:

   begin cdr_exe_msg_queues_admin.stop_processing_queues; end; / 

   Wait until you see the "End Procedure" statement in the log.
4. Stop and disable the Oracle LSH job queue:

   begin
   cdr_exe_job_queues.stop_processing_queues;
   end;
   /

Abort the Long-Running Jobs

1. Log in to SQL*Plus as apps.
2. Run the following query to find the long running jobs:

   select * from cdr_jobs where job_status_rc like '%EXECUTING%';

3. Log in to the Oracle LSH application.
4. Navigate to Life Sciences Data Hub > Job Execution.
5. Search for the job using the job ID and cancel it.

Cancel the Sessions Holding Locks on Application Objects

1. Run the following query:

   SELECT 'alter system kill session'||''''||sid||','||serial#||''''||' immediate;'from v$session where sid in ( select session_id FROM sys.dba_ddl_locks 
   WHERE (name like 'CDR_%' or name like 'DME_%') );

2. Run the alter statement to cancel the active sessions.

Disconnect Blocking Sessions

Before you upgrade, check for and stop any current database sessions.

1. If WebLogic Server is running, stop it. See Oracle® Fusion Middleware Administering Server Startup and Shutdown for Oracle WebLogic Server (12.2.1.3) at https://docs.oracle.com/middleware/12213/wls/START/.
   Log files for the AdminServer and the DMWServer are located in:

   middleware_home/user_projects/domains/DMWDomain/servers/AdminServer/logs

   and

   middleware_home/user_projects/domains/DMWDomain/servers/DMWServer/logs

2. Log in to SQL*Plus as apps.
3. Run the following query to find current sessions:

   SELECT 'USER: '||s.username||' SID: '||s.sid||' SERIAL #: '||S.SERIAL# "USER 
   HOLDING LOCK", s.inst_id 
   FROM gv$lock l 
   ,dba_objects o 
   ,gv$session s 
   WHERE l.id1 = o.object_id 
   AND s.sid = l.sid 
   AND o.owner = 'CDR' 
   AND o.object_name = 'DME_DISC_WORKTABLIST'; 

   This query returns the user, SID, serial number, and instance ID of each current session.
4. Disconnect each current session, passing in the SID and serial number:

   alter system disconnect session 'SID, serial_number' IMMEDIATE

Apply the Oracle Warehouse Builder (OWB) Patch

The LSH and DMW 2.4.8.3 release is certified for use with OWB patch 18146494. The OWB patch 18146494 addresses the issue with OWB trace file generation when installing Transformation and Datamodel.

Note:

Apply OWB patch 18146494 before installing the 2.5 release for Oracle LSH and Oracle DMW. You can download the patch and access the Readme on My Oracle Support (https://support.oracle.com).

Install Oracle Life Sciences Data Hub 2.5

Follow the instructions in the Install Oracle LSH 2.5 and Install Online Help topics.

Change Your FND_Validation_Level Profile

Change the setting of the FND_Validation_Level profile. In previous releases a setting of NONE was required, but now a setting of ERROR is required.

1. Open your Oracle LSH URL.
2. Log on with the system administrator account. An E-Business Suite screen opens.
3. In the Main Menu pane, expand the System Administrator (not System Administration) node, then Profile, and then click System.

   A new browser screen opens with several windows open and the Find System Profile Values window on top.

4. In the Profile field, enter FND_Validation_Level.
5. Click Find.
6. In the Site column, use the drop-down list to set the value to Error.
7. In the File menu, select Save and Proceed. The system displays a message that the transaction is complete.
8. Click OK. The transaction message pop-up disappears.
9. Click the X in the upper right corner of the System Profile Values window to close the window.