Integrated Capture Abends with ORA-7445[lnxsni()] after Applying Oracle Database WinBP
(Doc ID 2495183.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.3.0.1.0 and laterMicrosoft 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.
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.
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 |