My Oracle Support Banner

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

Last updated on NOVEMBER 28, 2016

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.
***Checked for relevance on 27-Dec-2013***

Symptoms

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

Thu Jun 21 22:00:46 2012
Exception [type: ILLEGAL_INSTRUCTION, ] [] [PC:0x1406926EE, kcbipnns()]
ERROR: Unable to normalize symbol name for the following short stack (at offset 213):
Errors in file E:\ORACLE\diag\rdbms\navdev\navdev\trace\navdev_ora_556.trc  (incident=105881):
ORA-07445: exception encountered: core dump [kcbipnns()] [ILLEGAL_INSTRUCTION] [] [PC:0x1406926EE] [] []
Incident details in: E:\ORACLE\diag\rdbms\navdev\navdev\incident\incdir_105881\navdev_ora_556_i105881.trc
Use ADRCI or Support Workbench to package the incident.

Alert log reports warning messages

Warning: Aq_tm_processes Is Set To 0 

 Incident trace file generated by the error indicates it has trouble intializing 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

Dump continued from file: E:\ORACLE\diag\rdbms\navdev\navdev\trace\navdev_ora_556.trc
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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.