Hitting ORA-07445 Ntel_new_memcpy While Creating Queue Table SYS.DBMS_AQADM.CREATE_QUEUE_TABLE (Doc ID 1900044.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

On : 11.2.0.3 version, Internals Errors (ORA-600 & ORA-7445)

Getting ORA-07445 __intel_new_memcpy while creating queue table SYS.DBMS_AQADM.CREATE_QUEUE_TABLE with editions enabled.

SYS.DBMS_AQADM.CREATE_QUEUE_TABLE
  3    4
  5  (
  6    7  QUEUE_TABLE => 'APPLSYS.WF_NOTIFICATION_OUT'
  8  ,QUEUE_PAYLOAD_TYPE => 'SYS.AQ$_JMS_TEXT_MESSAGE'
  9  ,COMPATIBLE => '8.1' ,STORAGE_CLAUSE => 'NOCOMPRESS
 10   11  TABLESPACE APPS_TS_QUEUES
 12  RESULT_CACHE (MODE DEFAULT)
 13  PCTUSED 0
 14  PCTFREE 10 INITRANS 1
 15   16  MAXTRANS 255 STORAGE (
 17   18  INITIAL 128K
 19  NEXT 128K
 20  MINEXTENTS 1 MAXEXTENTS UNLIMITED
 21   22  PCTINCREASE 0
 23  BUFFER_POOL DEFAULTFLASH_CACHE DEFAULT
 24   25  CELL_FLASH_CACHE DEFAULT)'
 26   27  ,SORT_LIST => 'PRIORITY,ENQ_TIME'
 28  ,MULTIPLE_CONSUMERS => TRUE ,MESSAGE_GROUPING => 0
 29   30  ,COMMENT => 'Workflow JMS Topic',SECURE => FALSE
 31   32  ); End;
 33   34
 35  /
ORA-07445: exception encountered: core dump [__intel_new_memcpy()+6080] [SIGSEGV] [ADDR:0xFA0] [PC:0x4B1AA70] [Address not mapped to object] []


----- Current SQL Statement for this session (sql_id=gyavszmjxks9n) -----
insert into
view$(obj#,cols,audit$,intcols,property,flags,textlength,text)values(:1,:2,:3,
:4,:5,:6,:7,:8)


ORA-07445: exception encountered: core dump [__intel_new_memcpy()+6080] [SIGSEGV] [ADDR:0xFA0] [PC:0x4B1AA70] [Address not mapped to object] []

pefccal->psdextp->rpiswu2->psdexsp->peftrusted->pextproc->spefmccallstd->
spefcmpa->kwqasvf->kwqaetx->kglfls->kglfls1->kqlchg->kqlobchg->kglspup->
kqldtu->kqldviu->kprball->rpiswu2->..->opiexe->insexe->qerltcFetch->
qerltcSingRowLoad-> aluate -> qesltcRpwOperandsEv->
kdtlo2l_opn_to_ldef-> pipe -> kdtlfetch-> pipe -> kdtlffp_fetch_from_ ->
kprccu->kprcdt->intel_fast_memcpy->intel_new_memcpy

 

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