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

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