After Upgrade, Some Packages Intermittently Fail with ORA-04065 ORA-06508
(Doc ID 370137.1)
Last updated on JUNE 21, 2023
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 |