My Oracle Support Banner

Upgrade R12.2.4 On 12c Fails With ORA-06598: insufficient INHERIT PRIVILEGES privilege (Doc ID 1946915.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2Cloud]
Information in this document applies to any platform.

Symptoms

On E-Business Suite (EBS) 12.2,
when attempting to apply RUP 12.2.4,
the following error occurs:

ATTENTION: All workers either have failed or are waiting:

  FAILED: file OE_SCHEDULE_LINES_TEMP.sql on worker 5.
  FAILED: file OE_ORDERORG_GTT.sql on worker 6.
  FAILED: file OE_CC_TEMP.sql on worker 8.

 

An error from the worker log file:

sqlplus -s APPS/***** @<DIR>fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '<DIR>/fs1/EBSapps/appl/ont/12.0.0/patch/115/sql/OE_SCHEDULE_LINES_TEMP.sql &un_ont'
Connected.

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 33

 


The issue can be reproduced at will with the following steps:
1. Apply RUP12.2.4

The issue has the following business impact:
Due to this issue, users cannot apply RUP12.2.4.

Changes

 No known changes. 

Cause

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
Symptoms
Changes
Cause
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.