My Oracle Support Banner

After Upgrade, Some Packages Intermittently Fail with ORA-04065 ORA-06508 (Doc ID 370137.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.2 [Release 9.2 to 12.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.



Symptoms

After upgrade, errors such as the one below occur intermittently:


The procedure name can be a dictionary object (DBMS_OUTPUT, DBMS_UTILITY are common examples) or a user created object.
Another possible symptom is the sudden object invalidation without an obvious cause.

DBA_REGISTRY shows all components as being valid.
The issue is not reproducible because of the intermittent nature of the error.

Changes

Known scenarios when such situations have occurred:

  • Database upgrade.
  • Privileges that were revoked and subsequently granted back, e.g.
    when revoking privileges from public and granting them to specific users

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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