Upgrade assistant fails with the error <schema-name> has unexpected object privileges on <object-name>
(Doc ID 2859830.1)
Last updated on JANUARY 22, 2024
Applies to:
Oracle SOA Suite - Version 12.1.3.0.0 to 12.2.1.4.0 [Release 12c]SOA on Marketplace - Version N/A and later
SOA Suite Cloud Service - Version N/A and later
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
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 |