Streams Apply Process Aborts after ORA-28501 received at Gateway Layer (Doc ID 1337656.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Affected Database: Oracle

Symptoms

Streams APPLY 11.1.0.7 aborts when foreign datastore DB2 experiences communication problem and errors in oracle with ORA-28501.

The apply server gets: ORA-07445: exception encountered: core dump [holrhscon()+02e8] [SIGSEGV] [ADDR:0x30B38F0000000329] [PC:0x10391CB68] [Address not mapped to object] []

The ORA-28501 is due to that fact that DB2 is disconnecting the idle thread once it is disconnected gateways will not reconnect

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