5.3 Install Oracle LSH 3.0

You must install the Oracle Life Sciences Data Hub 3.0 as a patch to Oracle Applications using AutoPatch. The patch, number 31136807, is on the media pack.

1. Unzip the patch to $APPL_TOP/patches.
2. Go to <PATCH_TOP>/cdr/patch/115/sql.
3. Edit the dme24indexupdatescript.sql file to replace the existing code with the following:

   REM $Header: dme24indexupdatescript.sql 120.1 2013/10/24 19:49:53 anathale noship $
   REM dbdrv: sql ~PROD ~PATH ~FILE none none none sqlplus &phase=tab+2 \
   REM dbdrv: checkfile(115.55=120.11):~PROD:~PATH:~FILE &un_fnd &un_apps
    
   SET VERIFY OFF;
   WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
   WHENEVER OSERROR EXIT FAILURE ROLLBACK;
   
    
   DECLARE
   BEGIN
                   NULL;
    
   EXCEPTION WHEN OTHERS THEN
     -- Raise exception if any error occurs, l_ErrorAt gives the object name where the execution failed.
     RAISE_APPLICATION_ERROR(-20010,'Error in partition table script at :' ||l_ErrorAt || '. Error: '||SQLERRM);
   END;
   /
    
   COMMIT;
   EXIT;

4. Apply the patch 31136807 using adpatch.