ORA-04029: Error ORA-7445 Occurred When Querying Fixed Table/View

(Doc ID 1911109.1)

Last updated on JULY 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Working in 11.2.0.4 (11.2.0.4.2) in a RAC environment the following error:

ORA-04029: error ORA-7445 occurred when querying Fixed Table/View

is raised while running a query from a v$ view in instance #1. This works fine in instance #2.

There is no ORA-7445 error reported in alert file or matching generated trace files.

NOTE:
The issue can also be seen in a single-instance database as it is not really RAC specific.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms