Getting ORA-07445: Core Dump [kkfdqc] Error on UNION ALL View
(Doc ID 1183993.1)
Last updated on OCTOBER 18, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2.0 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On 11.2.0.1 production, the following error is occurring:
ORA-07445: exception encountered: core dump [kkfdqc()+176] [SIGSEGV]
[ADDR:0x28] [PC:0x104611FB0] [Invalid permissions for mapped object] []
when a select from a view is performed:
----- PL/SQL Call Stack -----
object line object
handle number name
700000035f2c900 1053 package body SYS.DBMS_SQL
700000035fd1340 868 package body <package body name>
7000000340d0250 1 anonymous block
Select query of view <TEST> is failing
SQL> SELECT pga.row_id, pga.po_header_id, ou.NAME, pga.organization_id,
pga.enabled_flag, pvs.vendor_id, pvs.vendor_site_id, pvs.vendor_site_code,
DECODE (pga.organization_id, poh.org_id, 1, 2), pga.last_update_date, pga.last_updated_by, pga.creation_date, pga.created_by, pga.last_update_login, ou2.NAME, pga.purchasing_org_id
FROM TEST1 ou, TEST2 ou2, TEST3 pvs,
TEST_ASSIGNMENTS pga, TEST_HEADR poh
WHERE pga.po_header_id = poh.po_header_id
AND pga.organization_id = ou.organization_id
AND pga.vendor_site_id = pvs.vendor_site_id
AND pga.purchasing_org_id = ou2.organization_id
/
SELECT pga.row_id, pga.po_header_id, ou.NAME, pga.organization_id,
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
TEST View contains the problematic column row_id which is
filled in from TEST_ASSIGNMENTS
po_header_id,
organization_id,
enabled_flag,
vendor_site_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
purchasing_org_id
)
AS
SELECT /*+ PUSH_JOIN_PRED */
CHARTOROWID (ROWIDTOCHAR (ROWID)) row_id, "PO_HEADER_ID",
"ORGANIZATION_ID", "ENABLED_FLAG", "VENDOR_SITE_ID",
"LAST_UPDATE_DATE", "LAST_UPDATED_BY", "CREATION_DATE",
"CREATED_BY", "LAST_UPDATE_LOGIN", "PURCHASING_ORG_ID"
FROM <master object>@<dblink>
UNION ALL
SELECT /*+ PUSH_JOIN_PRED */
CHARTOROWID (ROWIDTOCHAR (ROWID)) row_id, "PO_HEADER_ID",
"ORGANIZATION_ID", "ENABLED_FLAG", "VENDOR_SITE_ID",
"LAST_UPDATE_DATE", "LAST_UPDATED_BY", "CREATION_DATE",
"CREATED_BY", "LAST_UPDATE_LOGIN", "PURCHASING_ORG_ID"
FROM <master name>
WITH READ ONLY
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |