My Oracle Support Banner

RCU Fails Loading OID Schemas With "ORA-04063: package body "ODS.TSPURGE" has errors" on DB 11.2.0.4 and 12.1 (Doc ID 1445389.1)

Last updated on OCTOBER 10, 2018

Applies to:

Oracle Fusion Middleware - Version 11.1.1.2.0 to 11.1.1.7.0 [Release Oracle11g]
Oracle Internet Directory - Version 11.1.1.2.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.
For 11.1.1.9 see - Load OID Schemas Failed With ORA-04063 for "ODS.TSPURGE" or ORA-01031 During Installing OID 11.1.1.9 on DB 11.2 / 12.1

Symptoms

  • RCU fails to load the OID schemas with the following errors in the RCU screen:
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
  •  The RCU oid.log also contains the same errors

Changes

Oracle Database Server 11.2.0.1+ is certified with FMW 11g (and OID) and have followed the System Requirements Guide as Installation Guide refers to:

http://docs.oracle.com/html/E18558_01/fusion_requirements.htm

The difference here is the 11.2.0.4 Patch Set, which has introduced changes related to default privileges.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.