ORA-04061, ORA-04065 Are Hit on Standby Database Environment
(Doc ID 3062855.1)
Last updated on DECEMBER 15, 2024
Applies to:
PL/SQL - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
An application that runs using Standby database fails with the following error intermittently
ORA-04061: existing state of package body "<schema_name>.<package_name>" has been invalidated
ORA-04065: not executed, altered or dropped package body "<schema_name>.<package_name>"
These errors are reported even though none of the objects referenced by the failing package is invalidated or recompiled manually.
Changes
The application was earlier running using the Primary database and no problem was reported at that time. The issue cropped up when the application started to use the Standby database.
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 |