My Oracle Support Banner

GoldenGate Apply Reader Is Failing With ORA-07445 [knalfProcessCurrentTxns()+1300] (Doc ID 2202141.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

At a target 12.1.0.2 database with multiple I-replicats, OGG 12.2.0.1.0 I-replicat  abends intermittently on failure to process a record for target table

For example :

 

WARNING OGG-01154 SQL error 1403 mapping FALCON.TM_SUMMARY_OF_CHANGES to FALCON.TM_SUMMARY_OF_CHANGE
S OCI Error ORA-01403: no data found, SQL D_NO" = :b1>.


When this occurs, the apply reader aborts with:

GoldenGate Apply Server AS15 for OGG$RRULES with pid=56 OS id=18499 stopped
GoldenGate Apply Server AS0A for OGG$RRULES with pid=43 OS id=20501 stopped
GoldenGate Apply Server AS1C for OGG$RRULES with pid=253 OS id=11944 stopped
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x28] [PC:0x104819AD4, knalfProcessCurrentTxns()+1300] [flags: 0x0, count: 1]
Errors in file /ora/app/oracle/diag/rdbms/gsap/gsap/trace/gsap_as0o_16032.trc (incident=110165):
ORA-07445: exception encountered: core dump [knalfProcessCurrentTxns()+1300] [SIGSEGV] [ADDR:0x28] [PC:0x104819AD4] [Address not mapped to object] []

 

From trace file generated

ORA-07445: exception encountered: core dump [knalfProcessCurrentTxns()+1300] [SIGSEGV] [ADDR:0x28] [PC:0x104819AD4] [Address not mapped to object] []

*** 2016-08-17 05:20:11.162
*** SESSION ID:(757.31513) 2016-08-17 05:20:11.162
*** CLIENT ID:() 2016-08-17 05:20:11.162
*** SERVICE NAME:(gsap.aipo.gov.au) 2016-08-17 05:20:11.162
*** MODULE NAME:(GoldenGate) 2016-08-17 05:20:11.162
*** CLIENT DRIVER:() 2016-08-17 05:20:11.162
*** ACTION NAME:(OGG$RATMOSS - Apply Receiver) 2016-08-17 05:20:11.162

knanrpeos: WARNING could not free enough streams pool memory:
knanrpeos: size = 8589934592, cca_alloc=7667144408, msgbody_allc=0
knanrpeos: msghdr_alloc=696

*** 2016-08-17 05:20:12.174
knanrpeos: WARNING could not free enough streams pool memory:
knanrpeos: size = 8589934592, cca_alloc=7726971568, msgbody_allc=0
knanrpeos: msghdr_alloc=696

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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