My Oracle Support Banner

Secure File Migration During Oracle Life Sciences Data Hub 3.1 Upgrade not completed even after 12 hrs (Doc ID 2798417.1)

Last updated on AUGUST 31, 2021

Applies to:

Oracle Life Sciences Data Hub - Version 3.1.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Life Sciences Data Hub (LSH) 3.1 Upgrade, As part of Secure File Migration, the script cdrsecfilepostinstscript.sql that was run as apps was in executing state even after 12 hrs.

As per the LSH 3.1 Install Guide the following query was run which showed that two jobs were in running state.


8.23.2 Monitor the Secure File Migration
SQL> select
owner,
job_name,
JOB_ACTION,
START_DATE,
ENABLED,
STATE
from dba_SCHEDULER_JOBS
where job_name like 'MIGRATE_BASICFILE_TO_SECUREFILE%';

OWNER
--------------------------------------------------------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------------------------------------------------------
JOB_ACTION
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
START_DATE ENABL STATE
--------------------------------------------------------------------------- ----- ---------------
APPS
MIGRATE_BASICFILE_TO_SECUREFILE_2
BEGIN cdr_securefile_migration.p_sfm_control_engine(2); END;
22-JUL-21 09.59.23.848980 AM -04:00 TRUE RUNNING

APPS
MIGRATE_BASICFILE_TO_SECUREFILE_1
BEGIN cdr_securefile_migration.p_sfm_control_engine(1); END;
22-JUL-21 09.59.23.800752 AM -04:00 TRUE RUNNING

Changes

 System was upgraded to Oracle LSH 3.1

Cause

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
Symptoms
Changes
Cause
Solution


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