Error while applying The Patch 10117518 , event though adgrants.sql script was executed on db tier, AutoPatch error: Please apply adgrants.sql file in database tier before applying this patch (Doc ID 1940401.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

 Error while applying patch 10117518 merged with 18040523, event though adgrants.sql script was executed on db tier:

Adpatch error:
Current target release is 12.0.6

AutoPatch error:
Please apply adgrants.sql file in database tier before applying this patch

You should check the file
/d90/oracle/EBS1/fs1/EBSapps/appl/admin/EBS1/log/adpatch.log

for errors.

Executed the adgrants.sql script on database tier, following the instructions in Patch 10117518 Readme:

-- copied the adgrants.sql from $APPL_TOP/admin to $ORACLE_HOME/appsutil
sqlplus "/as sysdba"
@adgrants.sql APPS
exit

Even so, the patch finishes with error, the version of adgrants.sql is the same in $APPL_TOP/admin (12.2 APPL_TOP) and the one delivered by 10117518 patch :
$Header: adgrants.sql 120.67.12020000.8 2012/10/05 15:19:21 sstomar ship $

 

Changes

 Applying the patch 10117518 using adpatch

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