My Oracle Support Banner

How To Fix The LSH Adapter Packages Via Re-Install/Upgrade Method (Doc ID 2231827.1)

Last updated on FEBRUARY 20, 2023

Applies to:

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

Goal

How To Fix The LSH Adapter Packages Via Re-Install/Upgrade Method

The DB health check output shows them in status FAILURE. For example:

--------- 8 Installed adapter package versions: FAILURE ----------------------

Please contact LSW Support for further information in case of failure.
ORACLECLINICAL_ADAPTER failures are known issues, tracked under <Bug 25119447>

********* FAILURE: BIP11G_ADAPTER_DOMAIN - BI Publisher 11g: CDR_W1C86_58108.CDR_BIP11G_SERVICES problems found *********

********* package spec mismatch: LOB Header: /* $Header: cdrbip11gadps.txt 120.0.12000240.2 2014/10/13 08:19:04 pumesh noship $*/ Source Header: /* $Header: cdratbinssrvcs.txt 120.0 2007/05/11 09:16:14 appldev noship $*/
********* package body mismatch: LOB Header: /* $Header: cdrbip11gadpb.txt 120.0.12000240.3 2014/10/22 08:25:43 pumesh noship $*/ Source Header: /* $Header: cdratbinssrvcb.txt 120.1 2013/09/30 16:55:36 ssabesan noship $*/

********* FAILURE: INFORMATICA_ADPTR_DOMAIN - Informatica: CDR_W1C86_1FF55.CDR_INFORMATICA_SERVICES problems found in body *********

********* package body mismatch: LOB Header: /* $Header: cdrinfadpb.txt 120.5.12000240.2 2015/06/12 19:40:11 jakrupa noship $*/ Source Header: /* $Header: cdrinfadpb.txt 120.5 2013/09/27 08:26:08 dkallavi noship $*/

********* FAILURE: ORACLECLINICAL_ADAPTER - Oracle Clinical Data Extract Incremental Views: CDR_W1C86_5A1EC.CDR_ATK_OC_DXINCViews_Services problems found *********

********* package spec mismatch: LOB Header: /* $Header: cdratocdxincvsrvcs.txt 120.0.12000240.2 2015/07/02 07:29:25 pumesh noship $*/ Source Header: /* $Header: cdratocdxincvs.txt 120.0.12000240.2 2015/07/02 07:24:20 pumesh noship $*/
********* package body mismatch: LOB Header: /* $Header: cdratocdxincvsrvcb.txt 120.0.12000240.3 2015/07/02 12:19:15 pumesh noship $*/ Source Header: /* $Header: cdratocdxincvb.txt 120.0.12000240.2 2015/07/02 07:26:03 pumesh noship $*/

********* FAILURE: ORACLECLINICAL_ADAPTER - Oracle Clinical Global Meta-data: CDR_W1C86_8A49.CDR_ATK_OC_GMETA problems found in body *********

********* package body mismatch: LOB Header: /* $Header: cdratocgmetab.txt 120.3.12000240.2 2015/06/26 09:07:15 pumesh noship $*/ Source Header: /* $Header: cdratocgmetab.txt 120.2 2007/10/03 18:27:33 ssabesan noship $*/

********* FAILURE: ORACLECLINICAL_ADAPTER - Oracle Clinical Labs: CDR_W1C86_251D.CDR_ATK_OC_LABS problems found in body *********

********* package body mismatch: LOB Header: /* $Header: cdratoclabb.txt 120.0.12000240.2 2015/06/25 14:29:22 pumesh noship $*/ Source Header: /* $Header: cdratoclabb.txt 120.0 2007/05/11 08:50:10 appldev noship $*/

********* FAILURE: ORACLEFAMILY_ADAPTER - Oracle Tables and Views: CDR_W1C86_C0F9.CDR_ATK_ORACLEDB problems found *********

********* package spec mismatch: LOB Header: /* $Header: cdratorcldbs.txt 120.3.12000240.3 2016/06/03 16:12:53 anathale noship $*/ Source Header: /* $Header: cdratorcldbs.txt 120.3 2013/09/30 16:56:49 ssabesan noship $*/
********* package body mismatch: LOB Header: /* $Header: cdratorcldbb.txt 120.10.12000240.7 2016/06/06 14:56:42 anathale noship $*/ Source Header: /* $Header: cdratorcldbb.txt 120.10 2013/09/30 16:56:41 ssabesan noship $*/

********* FAILURE: ORACLEFAMILY_ADAPTER - Oracle Tables and Views: CDR_W1C86_C0F9.CDR_ATK_ORACLEDB_SERVICES problems found in body *********

********* package body mismatch: LOB Header: /* $Header: cdratorcldbsrvcb.txt 120.4.12000240.3 2016/10/12 18:13:32 anathale noship $*/ Source Header: /* $Header: cdratorcldbsrvcb.txt 120.4 2012/01/13 07:38:39 dkallavi noship $*/

********* FAILURE: TEXT EXPORT - TEXT EXPORT: CDR_W1C86_11621.CDR_ATK_DM_TEXT_SERVICES problems found *********

********* package spec mismatch: LOB Header: /* $Header: cdratdmtextsrvcs.txt 120.2.12000240.2 2014/09/22 19:07:20 anathale noship $*/ Source Header: /* $Header: cdratsassrvcs.txt 120.4 2009/05/21 21:36:51 ctankasa noship $*/
********* package body mismatch: LOB Header: /* $Header: cdratdmtextsrvcb.txt 120.6.12000240.2 2015/06/23 18:56:55 jakrupa noship $*/ Source Header: /* $Header: cdratdmtextsrvcb.txt 120.6 2013/09/30 16:55:44 ssabesan noship $*/

 

 

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
References


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