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 to [Release 11.2]
Information in this document applies to any platform.


On, 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


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