ORA-4029 and ORA-7445 [kglic_cbk] on MVIEW Refresh (DBMS_SNAPSHOT) (Doc ID 1393534.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

On 11.2.0.2, materialized view refresh (DBMS_SNAPSHOT) fails with the following error stack:

ORA-12012: error on auto execute of job "USD"."REFRESH_1167"
ORA-27476: "SYS.IDX_RB$CLASS_445" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 433
ORA-06512: at "SYS.DBMS_SCHEDULER", line 845
ORA-06512: at "SYS.DBMS_I_INDEX_UTL", line 1543                                  <---
ORA-04029: error ORA-7445 occurred when querying Fixed Table/View          <---
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2566
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2779
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2748
ORA-06512: at line 1


In the trace file generated for 'ORA-04029: error ORA-7445 occurred', the current SQL is:

select count(*) from v$db_pipes



The call stack looks similar to:

kglic_cbk <-- kglic0 <-- kqlfto



ORA-4029 is under these circumstances reproducible by SELECT against V$DB_PIPES:

SQL> select count(*) from v$db_pipes;
select count(*) from v$db_pipes
*
ERROR at line 1:
ORA-04029: error ORA-7445 occurred when querying Fixed Table/View



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