ORA-07445, core dump [kkqteParseSqlForPG()] [SIGSEGV] upon execution of a SQL (Doc ID 1327807.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms


=== ODM Issue Clarification ===
After upgrade to 11.2, sometimes user session fails with ORA-03113 : end-of-file communication.
Lots of ORA-07445 [kkqteParseSqlForPG]  reported in alert log with the below error.
e.g.
ORA-07445: exception encountered: core dump [kkqteParseSqlForPG()+...] [SIGSEGV] [ADDR:...] [PC:0x.......] [Invalid permissions for mapped object] []

Changes

Any changes , knowingly / unknowingly that made local indexes unusable on some of the partition/sub-partition table on another schema those are referenced in the failing query.

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