SQL> conn / as sysdba

Connected.

SQL> exec dbms_utility.compile_schema('SERVICEACCT');

BEGIN dbms_utility.compile_schema('SERVICEACCT'); END;

*

ERROR at line 1:

ORA-20000:

ORA-06512: at "SYS.DBMS_UTILITY", line 347

ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal

ORA-06512: at line 1

Cause

SYS does not have the required privileges to run the procedure.

Solution

To check whether SYS has the required privileges, run the following query connected as SYS:

SQL> select username, privilege from user_sys_privs order by privilege;

If SYS does not have the following privileges, then grant them to SYS directly:

CREATE ANY DIMENSION
CREATE ANY EVALUATION CONTEXT
CREATE ANY INDEX
CREATE ANY INDEXTYPE
CREATE ANY LIBRARY
CREATE ANY MATERIALIZED VIEW
CREATE ANY OPERATOR
CREATE ANY PROCEDURE
CREATE ANY RULE
CREATE ANY RULE SET
CREATE ANY SYNONYM
CREATE ANY TRIGGER
CREATE ANY TYPE
CREATE ANY VIEW

hope this helps