ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250]

哎呀我的天吶發表於2022-10-27

當前資料庫版本

xstream停掉了

XStream Apply Reader AS01 for DBZXOUT22 with pid=154 OS id=36804 stopped
XStream Apply Server AS02 for DBZXOUT22 with pid=155 OS id=36807 stopped
2022-10-27T16:03:26.075297+08:00
XStream APPLY AP01 for DBZXOUT22 with pid=8, OS id=36802 stopped
2022-10-27T16:03:26.075393+08:00
Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ap01_36802.trc:
ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250], [], [], [], [], [], [], [], [], [], [], []
2022-10-27T16:03:29.089498+08:00
XStream Outbound Server for DBZXOUT22 with pid=138 OS id=241066 stopped
2022-10-27T16:03:29.089881+08:00
Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ora_241066.trc:
ORA-26804: Apply "DBZXOUT22" is disabled.
2022-10-27T16:03:29.106080+08:00

trace 日誌

oldest_pos_knamxld=0000000002c64a7a
oldest_pos_knacctx=0000000002c6ef35
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: Apply Coordinator work bucket
DATA
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Trace Bucket Dump End: Apply Coordinator work bucket
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: Apply Coordinator history bucket
DATA
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Trace Bucket Dump End: Apply Coordinator history bucket
ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0
ksvp2penabled: ep = 0x7f27e0300970, rpr = 0x50de79490
*** 2022-10-27T16:02:02.388611+08:00
<error barrier> at 0x7ffe4bba08e0 placed ksv.c@7154
ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250], [], [], [], [], [], [], [], [], [], [], []
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250], [], [], [], [], [], [], [], [], [], [], []

Bug 32338220  xf21.3sec_ols2 - trc - knacpft_processfetchedtxns - ORA-600 [knacpft_processfetchedtxns250]

 This note gives a brief overview of bug 32338220.
 The content was last updated on: 12-OCT-2022
  Click  here for details of each of the sections below.

Affects:

Product ( Component) Oracle Server (Rdbms)
Range of versions  believed to be affected Versions BELOW 21.3
Versions  confirmed as being affected
Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 32338220 is first included in

Interim patches may be available for earlier versions - click   to check.

Symptoms:

Related To:

Description

XStream Out may encounter ORA-600 [knacpft_ProcessFetchedTxns250] because
 the oldest_scn is set incorrectly.
  
REDISCOVERY INFORMATION:
 If XStream Out apply aborted due to ORA-600 [knacpft_ProcessFetchedTxns250]
 then it may be due to this bug.  
Workaround
 NONE

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-2920701/,如需轉載,請註明出處,否則將追究法律責任。

相關文章