Streams Apply Fails With ORA-7445 [kgscDump] and ORA-7445 [kxsxsi] (Doc ID 756686.1)

Last updated on APRIL 20, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later    [Release: 9.2 and later]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 9.2.0.8
Oracle Server Enterprise Edition - Version: 10.2.0.4

Symptoms

Streams Apply Reader process may abort due to ORA-7445 errors:

In the alert log you may see errors similar to:

ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [Address not mapped to object] [0x000010019] [] []
ORA-07445: exception encountered: core dump [kxsxsi()+414] [SIGSEGV] [Address not mapped to object] [0x000100009] [] []
Streams Apply Reader P000 pid=... OS id=... stopped
ORA-10388: parallel query server interrupt (failure)

In the trace file you may see a Streams update with many bind variables:

Current SQL statement for this session:
insert into "STREAMADMIN"."QUEUE_SCHEMA_TRS" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)

----- Call Stack Trace ----- 
....  kgscDump kxsDumpCursors curdmp ksudps ksedmp ssexhd ...

Searching through the trace file further, you may also see indications of ORA-01438.

7FFF26C7BF60 2D41524F 33343130 76203A38 65756C61 [ORA-01438: value]
7FFF26C7BF70 72616C20 20726567 6E616874 65707320 [ larger than spe]
7FFF26C7BF80 69666963 70206465 69636572 6E6F6973 [cified precision]
7FFF26C7BF90 6C6C6120 6465776F 726F6620 69687420 [ allowed for thi]
7FFF26C7BFA0 6F632073 6E6D756C 0000000A 00000000 [s column........]
7FFF26C7BFB0 00000000 00000000 00000000 00000000 [................]

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