ORA-07445 [kcbipnns()] when accessing AQ$ tables
(Doc ID 1477165.1)
Last updated on SEPTEMBER 25, 2019
Applies to:Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data .Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
Alert log reports error message ORA-07445 [kcbipnns()]
ERROR: Unable to normalize symbol name for the following short stack (at offset 213):
ORA-07445: exception encountered: core dump [kcbipnns()] [ILLEGAL_INSTRUCTION]  [PC:0x1406926EE]  ert log reports warning messages
Incident trace file generated by the error indicates it has trouble initializing the AQ process
*** SESSION ID:(189.151) 2012-06-21 22:00:46.917
*** CLIENT ID:() 2012-06-21 22:00:46.917
*** SERVICE NAME:(SYS$USERS) 2012-06-21 22:00:46.917
*** MODULE NAME:(emagent_AQMetrics) 2012-06-21 22:00:46.917
*** ACTION NAME:(DEQ) 2012-06-21 22:00:46.917
ORA-07445: exception encountered: core dump [kcbipnns()] [ILLEGAL_INSTRUCTION]  [PC:0x1406926EE]  
========= Dump for incident 105881 (ORA 7445 [kcbipnns()]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ILLEGAL_INSTRUCTION, ]  [PC:0x1406926EE, kcbipnns()]
Current SQL indicates the failure while accessing AQ$ tables
select 1 from "SYS"."AQ$_ALERT_QT_L" where msgid = :1 and subscriber# = :2 and name = :3 and address# = :4
Call stack of the error message
The value of parameter AQ_TM_PROCESSES is shown zero
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