Stream Apply Aborted : ORA-07445 [knipuerr23460()+99] And ORA-26786 (Doc ID 2449574.1)

Last updated on JULY 20, 2024

Applies to:

Goal

 Downstream Apply process aborted with the ORA-7445 [knipuerr23460()+99] in 11.2.0.4 version

Trace File Reports:

ORA-07445: exception encountered: core dump [knipuerr23460()+99] [SIGSEGV] [ADDR:0x0] [PC:0x7DE3F85] [Address not mapped to object] []
ORA-26786: A row with key ("TEST_ALERT_ID") = (1FD3D0302776455B8F348EF26F0C661A942BFAA2319B4487A882E92FBDA31B47) exists but has conflicting column(s) "MODIFIED_BY", "MODIFIED_ON", "USER_READ_ON", "TEST_ALERT_STATUS_ID" in table DCF_ALERTSWEB.TEST_ALERT
ORA-01403: no data found

Incident Trace files:

Problem Key: ORA 7445 [knipuerr23460()+99]
Error: ORA-7445 [knipuerr23460()+99] [SIGSEGV] [ADDR:0x0] [PC:0x7DE3F85] [Address not mapped to object] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: dbgeEndDDEInvocation [diag_dde]
[03]: ssexhd []
[04]: __sighandler []
[05]: knipuerr23460 []<-- Signaling
[06]: knipumax []
[07]: kniprup []
[08]: knipxup []
[09]: knipdis []
[10]: knaspd2 []
[11]: knaspd []
[12]: knasplcr []
[13]: knasplcrWrapper []
[14]: knaspx []
[15]: knalsProc1Txn []
[16]: knalsptxn []
[17]: knalsptxnReorder []
[18]: knasm2 []
[19]: knalsma []
[20]: knlkcbkma []
[21]: ksvrdp [ksv_trace]
[22]: opirip []
[23]: opidrv []
[24]: sou2o []
[25]: opimai_real []
[26]: ssthrdmain []
[27]: main []
[28]: __libc_start_main []
MD [00]: 'SID'='366.5387' (0x2)
MD [01]: 'ProcId'='138.104' (0x2)
MD [02]: 'Client ProcId'='oracle@bcglp2504052a.5065_140527401957120' (0x0)

Solution

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