Oracle 11g ORA-600 [kjbrcrcvt:lms] 問題處理
環境描述： Redhat Enterprise 7.9 Oracle 11.2.0.4 RAC 3節點
問題描述：資料庫節點3出現hang，等待事件為ges cgs registration。
問題原因：觸發Bug 30562200 - RAC instance crash due to ORA-600 [kjbrcrcvt:lms] ，RAC例項的LMS由於ORA-600 [kjbrcrcvt:lms]而出現故障
解決方案：應用補丁Bug 31321944 - Database Hang with 'gc current request'<='gc buffer busy acquire'
分析過程：
1、資料庫節點3日誌：
alertnode3 log: Errors in file /u01/app/oracle/diag/rdbms/prod/prod3/trace/prod3_lmse_48530_i169417.trc: ORA-00600: internal error code, arguments: [kjbrcrcvt:lms], [], [], [], [],[], [], [], [], [], [], [] ... *** 2022-10-10 14:07:06.629 *** SESSION ID:(649.1) 2022-10-10 14:07:06.629 *** CLIENT ID:() 2022-10-10 14:07:06.629 *** SERVICE NAME:(SYS$BACKGROUND) 2022-10-10 14:07:06.629 *** MODULE NAME:() 2022-10-10 14:07:06.629 *** ACTION NAME:() 2022-10-10 14:07:06.629 Dump continued from file: /u01/app/oracle/diag/rdbms/prodbprodb3/trace/prodb3_lmse_48530.trc ORA-00600: internal error code, arguments: [kjbrcrcvt:lms], [], [], [], [], [], [], [], [], [], [], [] ========= Dump for incident 169417 (ORA 600 [kjbrcrcvt:lms]) ======== ----- Beginning of Customized Incident Dump(s) ----- GCS RESOURCE 0xd889af92f0 hashq [0xd9f14cf3b0,0xd88f4287c0] name[0x115fe8.3f1] pkey 224175.0 grant 0xd590794580 cvt 0xd4c9dbc160 send 0xd590794580@0,148 write (nil),0@65536 *** 2022-10-10 14:07:06.645 dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0) ----- SQL Statement (None) ----- Current SQL information unavailable - no cursor. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- skdstdst()+41 call kgdsdst() 000000000 ? 000000000 ? 7FFCDB61CCA0 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? ksedst1()+103 call skdstdst() 000000000 ? 000000000 ? 7FFCDB61CCA0 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? ksedst()+39 call ksedst1() 000000000 ? 000000001 ? 7FFCDB61CCA0 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? dbkedDefDump()+2746 call ksedst() 000000000 ? 000000001 ? 7FFCDB61CCA0 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? ksedmp()+41 call dbkedDefDump() 000000003 ? 000000002 ? 7FFCDB61CCA0 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? ksfdmp()+69 call ksedmp() 000000003 ? 000000002 ? 7FFCDB61CCA0 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? dbgexPhaseII()+1764 call ksfdmp() 000000003 ? 000000002 ? 7FFCDB61CCA0 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? dbgexExplicitEndInc call dbgexPhaseII() 7F854B219748 ? 7F8547E37A98 ? ()+755 7FFCDB625AB8 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? dbgeEndDDEInvocatio call dbgexExplicitEndInc 7F854B219748 ? 7F8547E37A98 ? nImpl()+769 () 7FFCDB625AB8 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? dbgeEndDDEInvocatio call dbgeEndDDEInvocatio 7F854B219748 ? 7F8547E37A98 ? n()+52 nImpl() 7FFCDB625AB8 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? kjbrrefping()+4118 call dbgeEndDDEInvocatio 7F854B219748 ? 7F8547E37A98 ? n() 7FFCDB625AB8 ? 7FFCDB61CD78 ? 7FFCDB621820 ? 000000002 ? kjbmprefuse()+2177 call kjbrrefping() D889AF92F0 ? D4D7FF9948 ? 7FFCDB625AB8 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? kjmxmpm()+1014 call kjbmprefuse() 7F8543C141F8 ? D4D7FF9948 ? 7FFCDB625AB8 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? kjmpbmsg()+4706 call kjmxmpm() 7F8543C141F8 ? D4D7FF9948 ? 7FFCDB625AB8 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? kjmsm()+8021 call kjmpbmsg() 7F8543C141F8 ? D4D7FF9948 ? 7FFCDB625AB8 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? ksbrdp()+1045 call kjmsm() 7F8543C141F8 ? D4D7FF9948 ? 7FFCDB625AB8 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? opirip()+623 call ksbrdp() 7F8543C141F8 ? D4D7FF9948 ? 7FFCDB625AB8 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? opidrv()+603 call opirip() 000000032 ? 000000004 ? 7FFCDB628448 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? sou2o()+103 call opidrv() 000000032 ? 000000004 ? 7FFCDB628448 ? FFFFFFFF89AF9340 ? E5E37600010301 ? 1000800000000 ? opimai_real()+250 call sou2o() 7FFCDB628420 ? 000000032 ? 000000004 ? 7FFCDB628448 ? E5E37600010301 ? 1000800000000 ? ssthrdmain()+265 call opimai_real() 000000000 ? 7FFCDB628610 ? 000000004 ? 7FFCDB628448 ? E5E37600010301 ? 1000800000000 ? main()+201 call ssthrdmain() 000000003 ? 7FFCDB628610 ? 000000001 ? 000000000 ? E5E37600010301 ? 1000800000000 ? __libc_start_main() call main() 000000003 ? 7FFCDB6287B0 ? +245 000000001 ? 000000000 ? E5E37600010301 ? 1000800000000 ? _start()+41 call __libc_start_main() 000A177F0 ? 000000001 ? 7FFCDB6287A8 ? 000000000 ? E5E37600010301 ? 1000800000000 ? --------------------- Binary Stack Dump --------------------- 參考文件：Bug 31321944 - Database Hang with 'gc current request'<='gc buffer busy acquire' (Doc ID 31321944.8) Bug 30562200 - RAC instance crash due to ORA-600 [kjbrcrcvt:lms] -- Fix has regressed and replaced with fix in 31321944.8 (Doc ID 30562200.8)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28373936/viewspace-2918601/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【ERROR】儲存鏈路問題造成oracle錯誤，ora-600[4193] 問題處理ErrorOracle
- redhat7 搭建oracle 11g RAC 問題與處理RedhatOracle
- oracle SP2-問題處理Oracle
- 【故障處理】ORA-600:[13013],[5001]故障處理
- Oracle日常問題處理ORA-04031Oracle
- ORACLE問題處理十個指令碼Oracle指令碼
- linux處理oracle問題常用命令LinuxOracle
- ORACLE 11G DATAGUARD 日誌中斷處理方案Oracle
- Oracle 11G PSU 31326410 PSU apply failed 處理-拾億OracleAPPAI
- oracle ora-600[2662]問題分析及異常恢復Oracle
- Oracle CPU使用率過高問題處理Oracle
- ORACLE懸疑分散式事務問題處理Oracle分散式
- pyinstaller打包cx_Oracle庫問題處理記錄Oracle
- oracle系統表空間過大問題處理Oracle
- Oracle 記一次ORA-00001問題處理Oracle
- Oracle資料庫中的逐行處理問題NEOracle資料庫
- OracleORA-03113 ORA-600 [4193]故障處理Oracle
- 打Oracle PSU時碰到的一些問題處理Oracle
- Oracle日常問題處理-資料庫無法啟動Oracle資料庫
- Oracle 11g RAC之HAIP相關問題總結OracleAI
- Oracle資料庫處理壞塊問題常用命令Oracle資料庫
- 如何處理Oracle資料庫中的壞塊問題(轉)Oracle資料庫
- golang json處理問題GolangJSON
- [git] git問題處理Git
- 模擬一則ORA-600 [4194][][]故障並處理
- Oracle OER 7451 in Load Indicator : Error Code = OSD-04500的問題處理OracleIndicatorError
- Oracle X9M ORA-15001 ORA-15018問題處理Oracle
- 銀河麒麟系統安裝ORACLE資料庫問題處理Oracle資料庫
- 併發問題處理方式
- Linux 問題處理集錦Linux
- 處理SQLServer errorlog滿問題SQLServerError
- 資料處理--pandas問題
- Ubuntu處理依賴問題Ubuntu
- Oracle SQL處理OracleSQL
- Oracle 11g 052題庫解析1Oracle
- PHP 開發版本問題處理PHP
- 【故障處理】TNS-04610問題
- JVM問題分析處理手冊JVM