My Oracle Support Banner

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 later
Information 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


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