ORA-07445: Exception Encountered: Core Dump [__intel_ssse3_rep_memcpy()+9184] [SIGSEGV] (Doc ID 1644234.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

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

Symptoms

When executing a select statement, the alert log reports:

ORA-07445: exception encountered: core dump [__intel_ssse3_rep_memcpy()+9184] [SIGSEGV] [ADDR:0x2B505B09EEBF] [PC:0x55AFFB0] [Invalid permissions for mapped object] []


The current sql from the trace file is like:

SELECT DISTINCT J.EMPLID , J.EMPL_RCD , A.NAME , A.LAST_NAME , A.FIRST_NAME , J.BUSINESS_UNIT , J.JOBCODE , JC.DESCR , J.DEPTID , D.DESCR , J.SUPERVISOR_ID , J.REPORTS_TO , J.LOCATION , L.DESCR , J.COMPANY , J.PAYGROUP , J.GP_PAYGROUP , ED.WORKGROUP , ED.TASKGROUP , J.POSITION_NBR , :"SYS_B_0" , :"SYS_B_1",:"SYS_B_2",:"SYS_B_3" FROM PS_JOBCODE_TBL JC, PS_JOB J, PS_TL_EMPL_DATA ED, PS_TL_GROUP_DTL F ,PS_TL_GRP_SECURITY S ,PS_PERSON_NAME A , PS_DEPT_TBL D, PS_LOCATION_TBL L WHERE S.TL_GROUP_ID = F.TL_GROUP_ID AND F.EMPLID = J.EMPLID AND F.EMPL_RCD = J.EMPL_RCD AND F.EMPLID = A.EMPLID AND F.EMPLID = ED.EMPLID AND F.EMPL_RCD = ED.EMPL_RCD AND S.ROWSECCLASS = :1 AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT


The call stack in the incident file written by the error contains the functions like:

... intel_ssse3_rep_memcpy intel_Fast_memcpy kpofcr qersoFetchSimple qersoFetch opifch2 opifch opiodr ttcpip opitsk opiino opiodr opidrv ...


The current cursor has the status CURROW, meaning that it is retrieving data.

 

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