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 JUNE 22, 2023

Applies to:

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

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