This KB article explains what permissions the database user needs in order to install the MDB on Oracle.
CA Service Management 17.x
All Supported Oracle versions
The Oracle user that runs the MDB installation must have the following database administrator privileges assigned:
COL$, DBA_CONSTRAINTS, DBA_CONS_COLUMNS, DBA_INDEXES, DBA_IND_COLUMNS, DBA_OBJECTS, DBA_OBJECT_TABLES, DBA_REGISTRY,DBA_TABLES, DBA_TABLESPACES, DBA_TAB_COLUMNS, DBA_TAB_PRIVS, DBA_VIEWS, DBMS_REGISTRY, EXPDEPACT$, EXPDEPOBJ$, EXPPKGACT$,EXPPKGOBJ$, KOPM$, OBJ$, TS$, USER$