今天在巡檢時候發現alert日誌中列出了一下錯誤，在oracle support上也查不到錯誤描述。
該錯誤是oracle10g 10.1版本的一個bug，在10.2版本修復了，不知道這個結論使用者是否能接受。

截選日誌如下
Sat Mar 29 08:35:01 2014

Errors in file c:\oracle\product\10.1.0\admin\ecms\bdump\ecms_j002_3680.trc:

ORA-00600: 內部錯誤程式碼, 引數: [kcrf_pvt_strand_bind1], [1], [0], [3], [4], [2], [], []

Sat Mar 29 08:35:08 2014

Errors in file c:\oracle\product\10.1.0\admin\ecms\bdump\ecms_j002_3680.trc:

ORA-00600: 內部錯誤程式碼, 引數: [kcrf_pvt_strand_bind1], [1], [0], [3], [4], [2], [], []

ORA-06512: 在 "SYS.DBMS_SNAPSHOT", line 1883

ORA-06512: 在 "SYS.DBMS_SNAPSHOT", line 2089

ORA-06512: 在 "SYS.DBMS_IREFRESH", line 683

ORA-06512: 在 "SYS.DBMS_REFRESH", line 195

ORA-06512: 在 line 1

Sat Mar 29 08:35:11 2014

Errors in file c:\oracle\product\10.1.0\admin\ecms\bdump\ecms_j003_3684.trc:

ORA-00600: 內部錯誤程式碼, 引數: [kcrf_pvt_strand_bind1], [1], [0], [5], [6], [2], [], []

ORA-06512: 在 "SYS.DBMS_SNAPSHOT", line 1883

ORA-06512: 在 "SYS.DBMS_SNAPSHOT", line 2089

ORA-06512: 在 "SYS.DBMS_IREFRESH", line 683

ORA-06512: 在 "SYS.DBMS_REFRESH", line 195

ORA-06512: 在 line 1

該trace資訊擷取如下
*** SERVICE NAME:(SYS$USERS) 2012-06-15 04:20:45.468
*** SESSION ID:(67.1) 2012-06-15 04:20:45.468
*** 2012-06-15 04:20:45.468
ksedmp: internal or fatal error
ORA-00600: 內部錯誤程式碼, 引數: [kcrf_pvt_strand_bind1], [1], [0], [3], [4], [2], [], []
Current SQL statement for this session:
update system.def$_destination set last_delivered = :1, last_enq_tid = :2, last_seq = :3, last_txn_count = :4, total_txn_count = total_txn_count + :5, total_prop_time_throughput = total_prop_time_throughput + :6, total_prop_time_latency = total_prop_time_latency + :7, to_communication_size = to_communication_size + :8, from_communication_size = from_communication_size + :9, spare1 = spare1 + :10, spare2 = spare2 + :11, spare3 = spare3 + :12, spare4 = spare4 + :13 where rowid = :14
----- PL/SQL Call Stack -----
object line object
handle number name
6D306D5C 735 package body SYS.DBMS_ASYNCRPC_PUSH
6D4477E0 2857 package body SYS.DBMS_DEFER_SYS
6D4FF034 1742 package body SYS.DBMS_SNAPSHOT
6D4FF034 2089 package body SYS.DBMS_SNAPSHOT
6D55A230 683 package body SYS.DBMS_IREFRESH
6D57E6D4 195 package body SYS.DBMS_REFRESH
6D598A4C 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+524 CALLrel _ksedst+0 0
_ksfdmp.160+14 CALLrel _ksedmp+0 3
_kgerinv+133 CALLreg 00000000 6301450 3
_kgeasnmierr+19 CALLrel _kgerinv+0 6301450 7D51090 341A05C 5
7C8B86C
__VInfreq__kcrf_pvt CALLrel _kgeasnmierr+0 6301450 7D51090 341A05C 5 0 1
_strand_bind+ 0 0 0 0 0 3 0 0 4 0 0 2 0
_ktiImuPoolAllocate CALLrel _kcrf_pvt_strand_bi 6F338930 4
.152+137 nd+0
_ktiTxnPoolAllocate CALLrel _ktiImuPoolAllocate
+167 .152+0
_ktcxbr0+1358 CALLrel _ktiTxnPoolAllocate 1E602C64 0 34258F0
+0
_ktaiam.94+105 CALLrel _ktcxbr0+0 0 7FFFFFFF 0
_ktagetg0+186 CALLrel _ktaiam.94+0
_ktagetp+75 CALLrel _ktagetg0+0
_ktagetg+57 CALLrel _ktagetp+0
_ktagdw.94+75 CALLrel _ktagetg+0 11F4 0 3 1 1 0 0 0 0
_ktaadm+185 CALLrel _ktagdw.94+0 11F4 3 3 1 0 0 0
_kksfbc+1884 CALLrel _ktaadm+0 6D2B4634 0
_opiexe+1682 CALLrel _kksfbc+0 621D1D0 3 102 0 0 0 7C8C5B8
7C8C55C 0
_opiall0+1570 CALLrel _opiexe+0 49 3 7C8CB70
_opikpr+525 CALLrel _opiall0+0 65 22 7C8CD3C 0 0 7C8CDD4 206
0 0 0 0 0 0
_opiodr+977 CALLreg 00000000 65 14 8741788
_rpidrus.66+150 CALLrel _opiodr+0 65 14 8741788 22
_rpidru+88 CALLrel _rpidrus.66+0 7C8D010
_rpiswu2+368 CALLreg 00000000 7C8D404
_kprball+1382 CALLrel _rpiswu2+0 1E45DB2C 0 7C8D384 2 7C8D3A4
0 7C8D384 0 6B5658 6B5508
7C8D404 8
_knpcdp_Put+271 CALLrel _kprball+0
_knpc_rwm_RecordWat CALLrel _knpcdp_Put+0
erMark+61
_knpc_nwm_NoteWater CALLrel _knpc_rwm_RecordWat 8741564
Mark+73 erMark+0
_knpc_puicd+1141 CALLrel _knpc_nwm_NoteWater 8741564 1
Mark+0
_pevm_icd_call_comm CALLreg 00000000 7D7E5A8 7 7D4EA30
on+465
_pfrinstr_ICAL+162 CALLrel _pevm_icd_call_comm
on+0
_pfrrun_no_tool+51 CALL??? 00000000
_pfrrun+1834 CALLrel _pfrrun_no_tool+0 7D7E5A8 6D3C5336 7D7E5E4
_plsql_run+1051 CALLrel _pfrrun+0 7D7E5A8
_peicnt+179 CALLrel _plsql_run+0 7D7E5A8 1 0
_kkxexe+477 CALLrel _peicnt+0
_opiexe+4896 CALLrel _kkxexe+0 6D598A4C
_opiodr+977 CALLreg 00000000 4 4 7C8E7F8
_rpidrus.66+150 CALLrel _opiodr+0 4 4 7C8E7F8 5
_rpidru+88 CALLrel _rpidrus.66+0 7C8E3BC
_rpiswu2+368 CALLreg 00000000 7C8E6F4
_rpidrv+298 CALLrel _rpiswu2+0
_rpiexe+70 CALLrel _rpidrv+0 5 4 7C8E7F8 A
_kkjex1e+3360 CALLrel _rpiexe+0 5 5 3 7C8E928 4 3 0 0 0 0 0 0
_kkjsexe+293 CALLrel _kkjex1e+0 7C8EC3C 39 1 7C8EC10
_kkjrdp+720 CALLrel _kkjsexe+0
_opirip+681 CALLrel _kkjrdp+0
_opidrv+517 CALLrel _opirip+0 32 0 0
_sou2o+45 CALLrel _opidrv+0 32 0 0
_opimai+314 CALLrel _sou2o+0 7C8FE2C 32 0 0
_BackgroundThreadSt CALLrel _opimai+0
art@4+314
7C826060 CALLreg 00000000

ORA-00600: 內部錯誤程式碼, 引數: [kcrf_pvt_strand_bind1]

相關文章