环境描述: 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