Upgrade on 15.x fails with permissions issues related to SCHEMA_EXPORT/SYSTEM_GRANT

Products

• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

Upgrade fails depsite URT success, upgrade suggests permissions issue with SCHEMA_EXPRT/SYSTEM_GRANT or CREATE INDEXTYPE

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible
ORA-01031: insufficient privileges
Failing sql is:
GRANT CREATE INDEXTYPE TO "PROTECT_UPGRADE"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible
ORA-01031: insufficient privileges

Cause

Missing privileges not normally needing explicit grants. These are usually granted by higher level permissions.

Resolution

Execute the following grants as the sys user in Oracle:

grant DATAPUMP_IMP_FULL_DATABASE to <readiness_schema_user>;
grant IMP_FULL_DATABASE to <readiness_schema_user>;