quinta-feira, 16 de janeiro de 2014

ORA-04063: package body "ODS.TSPURGE" has errors

If you are creating the Oracle Internet Directory schema in an Oracle database using RCU, you may encounter the following 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
To work around this issue:
  1. Stop RCU and drop any Oracle Internet Directory schemas already created. Refer to "Dropping Schemas" in Oracle Fusion Middleware Repository Creation Utility User's Guidefor instructions.
  2. Log into the database using SQL*Plus and run the following command:
     grant execute on sys.dbms_job to PUBLIC and grant execute on dbms_reputil to PUBLIC
  3. Run RCU again and create the schemas.

3 comentários:

Stevea4444 disse...

Thank you very much. You helped me resolve this issue.

ravi teja disse...

Thanks a lot.. This hack helped me to resolve the issue!

Derwin disse...

Good, thanks a lot