My Oracle Support Banner

Execution of cdradaptergrants.sql Script Ends with 'ORA-24344: success with compilation error' For CDR_ATK_OC_DESIGN_SERVICES Package Body (Doc ID 2667711.1)

Last updated on MAY 07, 2020

Applies to:

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


On Oracle Life Sciences Data Hub (LSH) 2.5.1 version,

When attempting to grant security rights to shared adapters,
after upgrading from LSH 2.5.0 to 2.5.1, the following error occurs:


The issue can be reproduced with the following steps:
1. Make sure that no LSH session is up and running.
2. Log in to SQL*Plus as apps.
3. Run $CDR_TOP/patch/115/sql/cdradaptergrants.sql


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

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