My Oracle Support Banner

Upgrade assistant fails with the error <schema-name> has unexpected object privileges on <object-name> (Doc ID 2859830.1)

Last updated on APRIL 07, 2022

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 to 12.2.1.4.0 [Release 12c]
Information in this document applies to any platform.

Goal

 While running the upgrade assistant customer is getting errors as

EXCEPTION Audit schema DEV_IAU has unexpected object privileges on PENDING_TRANS$ object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on UTL_RAW object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on V_$SESSION object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on V_$INSTANCE object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on GV_$SESSION object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on V_$ASM_DISKGROUP object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on ALL_ENCRYPTED_COLUMNS object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on DBA_2PC_PENDING object
EXCEPTION Audit schema DEV_IAU has unexpected object privileges on DBA_DATA_FILES object
EXCEPTION Audit schema DEV_IAU has unexpected DELETE object privilege on SCHEMA_VERSION_REGISTRY object
EXCEPTION Audit schema DEV_IAU has unexpected INSERT object privilege on SCHEMA_VERSION_REGISTRY object
EXCEPTION SELECT object privilege with grantable NO for object SCHEMA_VERSION_REGISTRY is missing in Audit schema DEV_IAU

 

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

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