After Upgrade, Some Packages Intermittently Fail with ORA-04065 ORA-06508
(Doc ID 370137.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 9.2 to 12.1]
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!