Getting Multiple ORA-600 and ORA-7445 From Streams (Doc ID 755070.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.4
10.2.0.4


Symptoms

Multiple Heap corruption type errors from apply slaves similar to the following: Issue can also present symptoms like:



ORA-00600: internal error code, arguments: [kgmtdllb1], [4098], [4000], [], [],
[], [], []
Streams Apply Server P001 pid=110 OS id=21744 stopped
Streams Apply Reader P000 pid=108 OS id=18797 stopped

ORA-00600: internal error code, arguments: [17114], [0xB5571FE8], [], [], [], [], [], []

ORA-10382: parallel query server interrupt (reset)




The symtoms can vary and most likely related to heap corruption ORA-600s and ORA-7445s.

 


ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [kghfrh:ds], [0x2A97E53788], [], [],
[], [], [], []

ORA-01438: value larger than specified precision allowed for this column
Current SQL statement for this session:
update /*+ streams restrict_all_ref_cons */ "NNUSER"."BNBILLINGEVENT" p set

ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [unknown
code] [0x000000000] [] []

ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2A97E53788],
[], [], [], [], [], []

 

 

 

Changes

 Errors are seen after applying 10.2.0.4 Patchset.

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