ORA-07445 [KZDMPVC()+2439] QUERIES WITH DATA REDACTION ENABLED (Doc ID 1928998.1)

Last updated on MAY 29, 2015

Applies to:

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

Symptoms

After applying 11.2.0.4.3 PSU patch, inline view query with redaction policy enabled fails with


    

ORA-07445: exception encountered: core dump [kzdmpvc()+2439] [SIGSEGV]
[ADDR:0x10] [PC:0x695E6E1] [Address not mapped to object] []

  

SQL> select * from (select a.numberx "NUMBER" from user1.test1 a union all
select case b.numberx when null then '' else b.numberx end "NUMBER" from
user1.vwcardx b);
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 10786
Session ID: 191 Serial number: 5

This same query worked before applying 11.2.0.4.3 (PSU3) patch.

The top of the call stack may include these modules: [kzdmpvc zdmrfsim qkebTraverseExpr qkebTraverseExpr kzdmpfqbso kzdmpvc ... ]

Changes

Applied the 11.2.0.4.3 (PSU3) patch

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