ORA-7445 occurs under qervwFetch() or qervwRestoreViewBufPtrs() when deleting from View with an INSTEAD OF Trigger (Doc ID 1674649.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When running a DELETE on a view having an instead-of trigger, it is possible to get an ORA-7445 under qervwRestoreViewBufPtrs() or qervwFetch() if the view has a column alias that is not referenced.

The issue does not occur on 11.2.0.3 or earlier and is seen after upgrade to 11.2.0.4 or 12.1.0.1.

 

RDBMS 11.2.04 reports:

ORA-07445: exception encountered: core dump [qervwRestoreViewBufPtrs()+nnnn] [SIGSEGV] [ADDR:0x0] [PC:0x250AABB] [Address not mapped to object] []

 RDBMS 11.2.0.4 / 12.1.0.1 report:

ORA-07445: exception encountered: core dump [qervwFetch()+nnnn] [SIGSEGV] [ADDR:0x0] [PC:0x2CA8DBD] [Address not mapped to object] []

 

 

The 'Call Stack' section of the incident trace file confirms the following stack information:

Incident Context Dump
---------------------

Problem Key: ORA 7445 [qervwRestoreViewBufPtrs()+nnnn]
...
[05]: qervwRestoreViewBufPtrs [SQL_Execution]<-- Signaling
[06]: qervwFetch [SQL_Execution]
[07]: qerdlFetch [SQL_Execution]
[08]: delexe [DML]
[09]: opiexe []
[10]: kpoal8 []
[11]: opiodr []
...

Problem Key: ORA 7445 [qervwFetch()+nnnn]
...
[04]: sslsshandler []<-- Signaling
[05]: __sighandler []
[06]: qervwFetch [SQL_Execution]
[07]: qerdlFetch [SQL_Execution]
[08]: delexe [DML]
...

 

Changes

The database was upgraded to 11.2.0.4 or 12.1.0.1.

The issue did not occur on earlier releases.

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