Session Crashes With ORA-07445[kkoiop()] with some specific SQL (Doc ID 1345618.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms


A specific SQL is crashing session with ORA-07445: exception encountered: core dump [kkoiop()+624] [SIGSEGV] [Address not mapped to object], see example below:

This SQL fails:

SELECT E.REMP_EMP_COD, E.REMP_CHAPA, E.NOME, E.DT_NASC, E.CPF, E.IDENT, e.situacao
FROM   reitoria.PT_PESSOA P,
UNIVERSAL.CONSULTA_SIT_DOCS_EMPREGADO E
WHERE  P.CD_EMPRESA   = E.REMP_EMP_COD
 AND  P.CD_MATRICULA = E.REMP_CHAPA
 AND  EXISTS (SELECT *
              FROM
                UNIVERSAL.CONSULTA_SIT_DOCS_EMPREGADO a
               WHERE A.REMP_CHAPA = 32603 AND A.REMP_EMP_COD = 10
                 AND (E.CPF = A.CPF OR E.IDENT = A.IDENT OR E.DT_NASC = A.DT_NASC))
and SITUACAO <> 'DEMITIDO'

If the last clause or the third clause is commented out, it works:

Example:

SELECT E.REMP_EMP_COD, E.REMP_CHAPA, E.NOME, E.DT_NASC, E.CPF, E.IDENT, e.situacao
FROM   reitoria.PT_PESSOA P,
UNIVERSAL.CONSULTA_SIT_DOCS_EMPREGADO E
WHERE  P.CD_EMPRESA   = E.REMP_EMP_COD
 AND  P.CD_MATRICULA = E.REMP_CHAPA
 AND  EXISTS (SELECT *
              FROM
                UNIVERSAL.CONSULTA_SIT_DOCS_EMPREGADO a
               WHERE A.REMP_CHAPA = 32603 AND A.REMP_EMP_COD = 10
                 AND (E.CPF = A.CPF OR E.IDENT = A.IDENT OR E.DT_NASC = A.DT_NASC))
-- and SITUACAO <> 'DEMITIDO'

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