AQ PROPAGATION ABORTED WITH ORA-600[OCIKSIN: INVALID STATUS] ON SYS.DBMS_AQADM_SYS.AQ$_PROPAGATION_PROCEDURE AFTER UPGRADE (Doc ID 1203544.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.


Symptoms

AQ propagation fail with below error:
ORA-600[OCIKSIN: INVALID STATUS] ON SYS.DBMS_AQADM_SYS.AQ$_PROPAGATION_PROCEDURE AFTER UPGRADE.

Sample Trace:


ORA-00600: internal error code, arguments: [Invalid Status], [OCIKSIN: Invalid Status], [18446744072664010992], [], [], [], [], [], [], [], [], []

========= Dump for incident 87956 (ORA 600 [Invalid Status]) ========

*** 2010-09-09 17:30:07.710
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=8az1s9vjf7zk4) -----
call SYS.DBMS_AQADM_SYS.aq$_propagation_procedure ( :0,:1,:2,:3,:4,:5,:6,:7,:8,:9 )
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xc6ddcae80 8645 package body SYS.DBMS_AQADM_SYS
0xc6ddcae80 9047 package body SYS.DBMS_AQADM_SYS

----- Call Stack Trace -----

dbgexProcessError
dbgeExecuteForError
dbgePostErrorKGE
dbkePostKGE_kgsf
kgeadse
kgerinv_internal
kgerinv
kgesinv
ksesin [KSE]
OCIKNSECA []<-- Signaling
kwqpstrmmsg0 [AQ]
kwqpdest [AQ]
kwqjswucb [AQ]
rpiswu2 []
: kwqjpropwin [AQ]
kwqjaq [AQ]
spefcmpa []
spefmccallstd []
pextproc []
peftrusted []
psdexsp []
rpiswu2 []
psdextp []
pefccal []
pefcal []
pevm_FCAL []
pfrinstr_FCAL []
pfrrun_no_tool []
pfrrun []
plsql_run []
peidxr_run []
peidxexe []
kkxdexe []
kkxmpexe []
kgmexwi []
kgmexec []
evapls []
evaopn2 []
kkxmexcs []
opiexe []
kpoal8 []
opiodr []
kpoodr []
upirtrc []
kpurcsc []
kpuexec []
OCIStmtExecute []
jslvec_execcb1 []
jslvswu []
jslve_execute0 []

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