Encountered ORA-04021: timeout occurred while waiting to lock object error while executing Install_TRC.sh during upgrade (Doc ID 2210493.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Healthcare Translational Research - Version 3.1 and later
Information in this document applies to any platform.

Symptoms

On : 3.1 version, Installation

When attempting to upgrade to TRC 3.1 from TRC 3.0.2.4 using the following command line:
sh ./install_TRC.sh -cdm_schema cdm -odb_schema odb -app_schema apps -enterprise_schema ent -db_conn pom31prd -cdm_indx_tablespace cdm_index_ts -index_tablespace odb_index_ts -lob_tablespace odb_lob_ts -promoter_offset 1000 -flanking_offset 1000 -partition_mode study -db_platform exadata -job_schema joben -job_store jobstore -job_index_tbs JOB_INDEX_TS -dbfs_tbs DBFS_DATA_TS -dbfs_lob_tbs DBFS_LOB_TS -max_parallel_degree 8

the following error occurs in the Install Error log.

ERROR
-----------------------
******************************************************************************************************************
Line 1866: FAIL 36: 'ORA-04021: timeout occurred while waiting to lock object', Rule 'pragma err forever ^ORA-.*'
******************************************************************************************************************
PL/SQL procedure successfully completed.

drop indexes

PL/SQL procedure successfully completed.

drop packages, views, procedure, function, java source
declare
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at line 9

Changes

 Upgrading to TRC 3.1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms