My Oracle Support Banner

Integrated Capture Abends with ORA-7445[lnxsni()] after Applying Oracle Database WinBP (Doc ID 2495183.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Microsoft Windows x64 (64-bit)

Symptoms

Integrated Capture abends after applying Oracle Database Windows Bundle Patch.

Output of ggserr.log:

2019-01-15T20:18:09.412-0800  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  EXTRACT EXTORA started.
2019-01-15T20:18:09.442-0800  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  Recovery initialization completed for target file .\dirdat\aa000000000, at RBA 1418.
2019-01-15T20:18:09.442-0800  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  Output file .\dirdat\aa is using format RELEASE 12.3.
2019-01-15T20:18:09.474-0800  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  Rolling over remote file .\dirdat\aa000000000.
2019-01-15T20:18:09.521-0800  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  Recovery completed for target file .\dirdat\aa000000001, at RBA 1479.
2019-01-15T20:18:09.521-0800  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  Recovery completed for all targets.
2019-01-15T20:18:09.786-0800  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  Setting session time zone to source database time zone 'GMT'.
2019-01-15T20:19:17.755-0800  ERROR   OGG-00662  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  OCI Error ORA-00447: fatal error in background process
                              (status = 447).
2019-01-15T20:19:18.022-0800  ERROR   OGG-02078  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  Extract encountered a fatal error in a processing thread and is abending.
2019-01-15T20:19:18.130-0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, EXTORA.prm:  PROCESS ABENDING.

Output of DB alert log:

2019-01-15T20:18:10.334199-08:00
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0] [PC:0x7FFE559B21F0, lnxsni()+2416]
ERROR: Unable to normalize symbol name for the following short stack (at offset 109):
dbgexProcessError()+398<-dbgePostErrorKGE()+2191<-dbkePostKGE_kgsf()+90<-kgeade()+453<-kgerelv()+151<-kgerev..4()+59<-kgerec5()+64<-sss_xcpt_EvalFilterEx()+2731<-sss_xcpt_EvalFilter()+243<-BackgroundThreadStart()+1148<-00007FFE5C99F2CB<-_GSHandlerCheck_SEH()+118<-00007FFE69C7D82D<-00007FFE69C2916B<-00007FFE69C7C9EE<-lnxsni()+2416<-krvrdassi_SaveShardInfo()+1169<-krvrdCBmddlSQL()+9348<-krvxInvokeCallbacks()+195<-krvxbitcc_InvokeTxCommitCallback()+89<-krvxbtpp_TransferTxPublicQ()+5076<-krvxbuild()+403<-krvxb_main()+62<-krvxmrs2()+2009<-krvxmrs()+424<-ksvrdp_int..0()+2556<-ksvrdp()+18<-opirip()+847<-opidrv()+960<-sou2o()+112<-opimai_real()+222<-opimai()+231<-BackgroundThreadStart()+702<-00007FFE690F168D<-00007FFE69C54629
Errors in file C:\...\<SID>_ms01_1004.trc  (incident=17355) (PDBNAME=CDB$ROOT):
ORA-07445: exception encountered: core dump [lnxsni()+2416] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x7FFE559B21F0] [UNABLE_TO_READ] []
Incident details in: C:\...\<SID>_ms01_1004_i17355.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

Changes

Apply Oracle Database Windows Bundle Patch.
This issue happens after applying the following patches.

- 12.2.0.1.180717 (<Patch:27937914>)
- 12.2.0.1.180831 (<Patch:28247681>)
 

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
Changes
Cause
Solution
References


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