- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
3#
发表于 2012-3-8 18:35:19
ODM Finding:
匹配ORA-600 internal error code, arguments: [krvuam1]和 knahfhcp=>krvsekd=>krvuam stack call的bug- Bug 8482079: ORA-00600 [KRVUAM1], [0] DURING LOG APPLY AND LOG APPLY STOPS
- Hdr: 8482079 10.2.0.2 RDBMS 10.2.0.2 DATAGUARD_LSBY PRODID-5 PORTID-212 5695562
- Abstract: ORA-600 [KRVUAM1], [0] DURING LOG APPLY AND LOG APPLY STOPS
- PROBLEM:
- --------
- Tue Apr 28 14:16:59 2009
- Errors in file
- /ora01/app/oracle/admin/iepprep/bdump/iepprep_p001_1200244.trc:
- ORA-600: internal error code, arguments: [krvuam1] , [0], [], [], [], [],
- [], []
- LOGSTDBY status: ORA-600: internal error code, arguments: [krvuam1] , [0],
- [], [], [], [], [], []
- Tue Apr 28 14:16:59 2009
- Errors in file
- /ora01/app/oracle/admin/iepprep/bdump/iepprep_lsp0_1564688.trc:
- ORA-12801 : error signaled in parallel query server P001
- ORA-600: internal error code, arguments: [krvuam1] , [0], [], [], [], [],
- [] , []
- Tue Apr 28 14:16:59 2009
- TLCR process death detected. Shutting down TLCR
- LOGSTDBY Apply process P005 pid=88 OS id=1142806 stopped
- LOGSTDBY Apply process P007 pid=90 OS id=1245192 stopped
- LOGSTDBY Apply process P004 pid=87 OS id=1421362 stopped
- Tue Apr 28 14:16:59 2009
- logminer process death detected, exiting logical standby
- LOGSTDBY Analyzer process P003 pid=86 OS id=1179772 stopped
- LOGSTDBY Apply process P008 pid=92 OS id=1196102 stopped
- LOGSTDBY Apply process P006 pid=89 OS id=1114318 stopped
- DIAGNOSTIC ANALYSIS:
- --------------------
- iepprep_p001_1200244.trc:
- ksedmp: internal or fatal error
- ORA-600: internal error code, arguments: [krvuam1], [0], [], [], [], [],
- [], []
- ----- Call Stack Trace -----
- calling call entry argument values in hex
-
- location type point (? means dubious value)
-
- -------------------- -------- --------------------
- ----------------------------
- ksedst+001c bl ksedst1 FFFFFFFFFFFAD70 ?
- 000000000 ?
- ksedmp+0290 bl ksedst 104811C38 ?
- ksfdmp+0018 bl 03F40A80
- kgerinv+00dc bl _ptrgl
- kgeasnmierr+0040 bl kgerinv 7000000ACA3E9A0 ?
- 00012FDF8 ?
- FFFFFE00000000 ? 000000000
- ?
- 100000000 ?
- krvuam+008c bl 01FAC578
- krvsekd+0504 bl krvuam FFFFFFFFFFFB2F0 ?
- 100FF0000000000 ?
- 000000000 ?
- 000000000 ? 000000000 ?
- 000007383 ?
- knahfhcp+034c bl krvsekd 110425FB0 ?
- 700000099824BF0 ?
- 1104A8AE0 ?
- FFFFFFFFFFFB482 ?
- FFFFFFFFFFFB480 ?
- FFFFFFFFFFFB488 ?
- FFFFFFFFFFFB484 ?
- 000000000 ?
- krvxInvokeCallbacks bl _ptrgl
- +0080
- krvxpirc_InvokeReco bl 01FAE540
- rdCallback+00e0
- krvxsagot_AgeGetOne bl krvxpirc_InvokeReco 000000000 ? 000000000 ?
- Tx+0814 rdCallback
- krvxsarafs_AgeReadA bl krvxsagot_AgeGetOne FFFFFFFFFFFB930 ?
- llFromSpillTable+07 Tx 10000001010 ?
- 18
- krvxsrckpt+0034 bl krvxsarafs_AgeReadA 110425FB0 ?
- llFromSpillTable
- krvxbini+0078 bl krvxsrckpt 000000001 ?
- krvxpri+00bc bl 01FABA18
- krvxmrs2+051c bl krvxpri 1049A98E0 ?
- krvxmrs+01b0 bl krvxmrs2
- kxfprdp+0954 bl _ptrgl
- opirip+04ac bl 01FAFC88
- opidrv+0448 bl opirip 110272210 ? 410273B50 ?
- FFFFFFFFFFFF6D0 ?
- sou2o+0090 bl opidrv 32031840BC ? 400000020 ?
- FFFFFFFFFFFF6D0 ?
- opimai_real+0150 bl 01FAB174
- main+0098 bl opimai_real 000000000 ? 000000000 ?
- __start+0090 bl main 00000000
- WORKAROUND:
- -----------
- None
- RELATED BUGS:
- -------------
- 8236342
- REPRODUCIBILITY:
- ----------------
- Customer's sql apply is stopped; it restarted on its own and then stopped
- again
- TEST CASE:
- ----------
- STACK TRACE:
- ------------
- ksedst+001c bl ksedst1 FFFFFFFFFFFAD70 ?
- 000000000 ?
- ksedmp+0290 bl ksedst 104811C38 ?
- ksfdmp+0018 bl 03F40A80
- kgerinv+00dc bl _ptrgl
- kgeasnmierr+0040 bl kgerinv 7000000ACA3E9A0 ?
- 00012FDF8 ?
- FFFFFE00000000 ? 000000000
- ?
- 100000000 ?
- krvuam+008c bl 01FAC578
- krvsekd+0504 bl krvuam FFFFFFFFFFFB2F0 ?
- 100FF0000000000 ?
- 000000000 ?
- 000000000 ? 000000000 ?
- 000007383 ?
- knahfhcp+034c bl krvsekd 110425FB0 ?
- 700000099824BF0 ?
- 1104A8AE0 ?
- FFFFFFFFFFFB482 ?
- FFFFFFFFFFFB480 ?
- FFFFFFFFFFFB488 ?
- FFFFFFFFFFFB484 ?
- 000000000 ?
- krvxInvokeCallbacks bl _ptrgl
- +0080
- krvxpirc_InvokeReco bl 01FAE540
- rdCallback+00e0
- krvxsagot_AgeGetOne bl krvxpirc_InvokeReco 000000000 ? 000000000 ?
- Tx+0814 rdCallback
- krvxsarafs_AgeReadA bl krvxsagot_AgeGetOne FFFFFFFFFFFB930 ?
- llFromSpillTable+07 Tx 10000001010 ?
- 18
- krvxsrckpt+0034 bl krvxsarafs_AgeReadA 110425FB0 ?
- llFromSpillTable
- krvxbini+0078 bl krvxsrckpt 000000001 ?
- krvxpri+00bc bl 01FABA18
- krvxmrs2+051c bl krvxpri 1049A98E0 ?
- krvxmrs+01b0 bl krvxmrs2
- kxfprdp+0954 bl _ptrgl
- opirip+04ac bl 01FAFC88
- opidrv+0448 bl opirip 110272210 ? 410273B50 ?
- FFFFFFFFFFFF6D0 ?
- sou2o+0090 bl opidrv 32031840BC ? 400000020 ?
- FFFFFFFFFFFF6D0 ?
- opimai_real+0150 bl 01FAB174
- main+0098 bl opimai_real 000000000 ? 000000000 ?
- __start+0090 bl main 000000000 ? 000000000 ?
- Hdr: 8236342 10.2.0.4 RDBMS 10.2.0.4 DATAGUARD_LSBY PRODID-5 PORTID-197 5695562
- Abstract: ORA-600 [KRVUAM1] CAUSED SQL APPLY TO STOP ON LOGICAL STANDBY
- PROBLEM:
- --------
- Thu Feb 5 01:35:44 2009
- Errors in file /u13/app/oracle/admin/ramprod/bdump/ramprod_ora_19214.trc:
- ORA-600: internal error code, arguments: [krvuam1] , [0], [], [], [], [],
- [], [
- ]
- Thu Feb 5 01:35:46 2009
- krvxerpt: Errors detected in process 21, role builder.
- Thu Feb 5 01:35:46 2009
- krvxmrs: Leaving by exception: 600
- Thu Feb 5 01:35:46 2009
- Errors in file /u13/app/oracle/admin/ramprod/bdump/ramprod_ora_19214.trc:
- ORA-600: internal error code, arguments: [krvuam1] , [0], [], [], [], [],
- [], [
- ]
- LOGSTDBY status: ORA-600: internal error code, arguments: [krvuam1] , [0],
- [],
- [], [], [], [], []
- Thu Feb 5 01:35:46 2009
- Errors in file /u13/app/oracle/admin/ramprod/bdump/ramprod_lsp0_23258.trc:
- ORA-12801 : error signaled in parallel query server P001
- ORA-600: internal error code, arguments: [krvuam1] , [0], [], [], [], [],
- [], [
- ]
- Thu Feb 5 01:35:46 2009
- TLCR process death detected. Shutting down TLCR
- logminer process death detected, exiting logical standby
- LOGSTDBY Analyzer process P003 pid=38 OS id=22702 stopped
- LOGSTDBY Apply process P004 pid=39 OS id=22706 stopped
- LOGSTDBY Apply process P007 pid=46 OS id=22716 stopped
- LOGSTDBY Apply process P008 pid=47 OS id=22718 stopped
- LOGSTDBY Apply process P005 pid=44 OS id=22710 stopped
- LOGSTDBY Apply process P006 pid=45 OS id=22714 stopped
- DIAGNOSTIC ANALYSIS:
- --------------------
- ramprod_ora_19214.trc:
- ORA-600: internal error code, arguments: [krvuam1] , [0], [], [], [], [],
- [], [
- ]
- ----- Call Stack Trace -----
- calling call entry argument values in hex
- location type point (? means dubious value)
- -------------------- -------- --------------------
- ----------------------------
- ksedst()+64 call ksedst1() 000000000 ? 000000001 ?
- ksedmp()+2176 call ksedst() 000000000 ?
- ksfdmp()+48 call ksedmp() 000000003 ?
- kgerinv()+304 call ksfdmp() C000000000000612 ?
- kgeasnmierr()+144 call kgerinv() 6000000000031340 ?
- krvuam()+96 call kgeasnmierr() 6000000000031340 ?
- krvsekd()+800 call krvuam() 9FFFFFFFFD1C30A0 ?
- knahfhcp()+1136 call krvsekd() 9FFFFFFFFD1C30A0 ?
- C00000157227AA38 ?
- krvxInvokeCallbacks call knahfhcp() 9FFFFFFFFD1C30A0 ?
- krvxpirc_InvokeReco call krvxInvokeCallbacks 9FFFFFFFFD1C30A0 ?
- krvxbpplcr_PostProc call krvxpirc_InvokeReco 9FFFFFFFFD1C30A0 ?
- krvxbpel_ProcessEnd call krvxbpplcr_PostProc 9FFFFFFFFD1C30A0 ?
- krvxbpdl_ProcessDat call krvxbpel_ProcessEnd 9FFFFFFFFD1C30A0 ?
- krvxbgen_GenericTx( call krvxbpdl_ProcessDat 9FFFFFFFFD1C30A0 ?
- krvxbuild()+784 call krvxbgen_GenericTx( 9FFFFFFFFD1C30A0 ?
- krvxmrs2()+2288 call krvxbuild() 9FFFFFFFFD1C30A0 ?
- krvxmrs()+560 call krvxmrs2() 60000000000B5D78 ?
- kxfprdp()+2784 call krvxmrs() 9FFFFFFFFFFFC930 ?
- opirip()+1600 call kxfprdp() 9FFFFFFFFFFFD470 ?
- $cold_opidrv()+1408 call opirip() 9FFFFFFFFFFFEDB0 ?
- sou2o()+336 call $cold_opidrv() 000000032 ?
- $cold_opimai_real() call sou2o() 9FFFFFFFFFFFF3F0 ?
- main()+368 call $cold_opimai_real() 000000003 ? 000000000 ?
- main_opd_entry()+80 call main() 000000003 ?
- WORKAROUND:
- -----------
- Rebuild logical standby which is not acceptable
- RELATED BUGS:
- -------------
- Bug 3918228
- REPRODUCIBILITY:
- ----------------
- TEST CASE:
- ----------
- STACK TRACE:
- ------------
- ksedst ksedmp ksfdmp kgerinv
- kgeasnmierr krvuam krvsekd knahfhcp krvxInvokeCallbacks krvxpirc_InvokeReco
- call krvxInvokeCallbacks krvxbpplcr_PostProc krvxbpel_ProcessEnd
- krvxbpdl_ProcessDat krvxbgen_GenericTx krvxbuild krvxmrs2 krvxmrs kxfprdp
- opirip $cold_opidrv sou2o $cold_opimai_real main main_opd_entry
- Bug 8528320: ORA-600 [KRVUAM1] IN THE LOGICAL STANDBY DATABASE
- Hdr: 8528320 10.2.0.4 RDBMS 10.2.0.4 DATAGUARD_LSBY PRODID-5 PORTID-197 ORA-600
- Abstract: ORA-600 [KRVUAM1] IN THE LOGICAL STANDBY DATABASE
- PROBLEM:
- --------
- The Logical Standby performs quite stange.
- The customer encounetered ORA-600
- ORA-600: internal error code, arguments: [krvuam1], [0], [], [], [], [],
- [], []
- ----- Call Stack Trace -----
- ksedst ksedmp ksfdmp kgerinv kgeasnmierr
- krvuam krvsekd knahfhcp
- krvxInvokeCallbacks
- krvxpirc_InvokeRecordCallbackkrvxbpplcr_PostProc call
- krvxpirc_InvokeRecoessLcr
- krvxbpel_ProcessEndLcr
- krvxbpdl_ProcessDataLcr
- krvxbgen_GenericTx
- krvxbuild krvxmrs2 krvxmrs kxfprdp
- opirip $cold_opidrv sou2o $cold_opimai_real
- main main_opd_entry
- ==========================
- Stack trace matches to Logical Standby ora-600 bug8236342, closed as
- duplicate of 5695562
- *** NOTES - See Note 66631.1 )******************
- BugTag: Support notes on Bug 5695562 - DDR info BugDesc 5695562
- Affects: RDBMS (-B1)
- NB: FIXED
- Abstract: Streams cannot capture inserts for IOT with overflow
- (ORA-
- 26773)
- Fixed-Releases: A205 B106
- Tags: COMPRESSKEY IOT STREAMS
- Details:
- Streams cannot capture some inserts for an IOT wITH overflow and
- compressed primary key index.
- ====================================
- The customer applied the patch to both Primary and Standby but it does not
- help
- ================
- The customer has uploaded lot's of traces to the SR
- Please let me know what you need
- DIAGNOSTIC ANALYSIS:
- --------------------
- none
- WORKAROUND:
- -----------
- 1. Skip processing a table
- 2. Let the Logical to catch up
- 3. Reinstantiate this table
- RELATED BUGS:
- -------------
- 8236342, closed as duplicate of 5695562
复制代码 |
|