Monday, April 20, 2015

ORA-04063, ORA_06508 and ORA-06512 when RCU for OID

Situation:
When trying to create the Oracle Internet Directory (OID) schema using Repository Creation Utility (RCU) I found these error messages:

ORA-04063: package body "ODS.TSPURGE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ODS.TSPURGE"
ORA-06512: at line 3

Solution:
1. Stop the RCU and drop any OID schemas already created.
2. Log into the database and execute the following commands:
GRANT EXECUTE ON sys.dbms_job TO PUBLIC;
GRANT EXECUTE ON dbms_reputil TO PUBLIC;
3. Run RCU again and create the OID schemas.