My Oracle Support Banner

ORA-07445 [kcbipnns()] when accessing AQ$ tables (Doc ID 1477165.1)

Last updated on SEPTEMBER 25, 2019

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.3 to 11.2.0.4 [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.

Symptoms

Alert log reports error message ORA-07445 [kcbipnns()]

Exception [type: ILLEGAL_INSTRUCTION, ] [] [PC:0x1406926EE, 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
Warning: Aq_tm_processes Is Set To 0 

 Incident trace file generated by the error indicates it has trouble initializing the AQ process

*** 2012-06-21 22:00:46.917
*** 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

----- Current SQL Statement for this session (sql_id=fn9w3zd3991m6) -----
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

kcbipnns kdst_fetch kdstf11001010000km kdsttgr qertbFetch opifch2 opiefn0 opiefn opiodr rpiswu2

The value of parameter AQ_TM_PROCESSES is shown zero

SQL> Show parameter AQ_TM_PROCESSES

Parameter          Value
------------------------------
AQ_TM_PROCESSES     0

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.