Upgrade Assistant Readiness Check Fails: Missing System and Object Privileges

When you reconfigure the domain, the upgrade assistant readiness check fails because of missing system and object privileges for OPSS Schema (DEV_IAU).

To solve the issue, complete the following steps:

  1. Provide the SCHEMA_VERSION_REGISTRY grant to following audit schemas:
    • DEV_IAU
    • DEV_IAU_APPEND
    • DEV_IAU_VIEWER

    For example: GRANT SELECT ON "SYSTEM"."SCHEMA_VERSION_REGISTRY" TO "DEV_IAU"

  2. Start the Upgrade Assistant.
    • (UNIX) ./ua -readiness
    • (Windows) ua.bat -readiness