After Upgrade, Some Packages Intermittently Fail with ORA-04065 ORA-06508
(Doc ID 370137.1)
Last updated on AUGUST 11, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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.
After upgrade, errors such as the one below occur intermittently:
ORA-06508: PL/SQL: could not find program unit being called:
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.
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
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