Oracle 启动后一会儿就挂掉故障处理—ORA-600 17182----惜分飞

联系：手机/微信(+86 17813235971) QQ(107644445)

标题：Oracle 启动后一会儿就挂掉故障处理—ORA-600 17182

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

一例正常运行的数据库突然节点不停重启(因为是rac,启动一会儿就crash,然后又被crs给启动起来,然后有crash,依次循环),告警日志类似:

Fri Mar 24 13:36:07 2023

QMNC started with pid=124, OS id=188397

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

Completed: ALTER DATABASE OPEN

Fri Mar 24 13:36:08 2023

minact-scn: Inst 1 is now the master inc#:2 mmon proc-id:188028 status:0x7

minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000

Fri Mar 24 13:36:08 2023

Starting background process CJQ0

Fri Mar 24 13:36:08 2023

CJQ0 started with pid=144, OS id=188451

Fri Mar 24 13:36:09 2023

Redo thread 2 internally disabled at seq 44406 (CKPT)

Archived Log entry 135343 added for thread 2 sequence 44405 ID 0xcd7086e0 dest 1:

ARC0: Archiving disabled thread 2 sequence 44406

Archived Log entry 135344 added for thread 2 sequence 44406 ID 0xcd7086e0 dest 1:

Thread 1 advanced to log sequence 40030 (LGWR switch)

  Current log# 2 seq# 40030 mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761

Archived Log entry 135345 added for thread 1 sequence 40029 ID 0xcd7086e0 dest 1:

Fri Mar 24 13:36:30 2023

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc  (incident=1082418):

ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082418/xff1_p200_188856_i1082418.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Mar 24 13:36:30 2023

Dumping diagnostic data in directory=[cdmp_20230324133630], requested by (instance=1, osid=188856 (P200)), summary=[incident=1082418].

Fri Mar 24 13:36:54 2023

Decreasing number of real time LMS from 6 to 0

Fri Mar 24 13:36:54 2023

Block recovery from logseq 40030, block 259 to scn 17199959182

Recovery of Online Redo Log: Thread 1 Group 2 Seq 40030 Reading mem 0

  Mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761

Block recovery stopped at EOT rba 40030.317.16

Block recovery completed at rba 40030.317.16, scn 4.20089998

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x97E8579, kghrst()+1835] [flags: 0x0, count: 1]

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc  (incident=1082419):

ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []

ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082419/xff1_p200_188856_i1082419.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc  (incident=1082420):

ORA-00600: internal error code, arguments: [17147], [0x7F4D2A13DBD0], [], [], [], [], [], [], [], [], [], []

ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []

ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082420/xff1_p200_188856_i1082420.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc  (incident=1082421):

ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x7F4D2A13DBE8], [], [], [], [], [], [], [], [], [], []

ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []

ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082421/xff1_p200_188856_i1082421.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Mar 24 13:36:56 2023

Dumping diagnostic data in directory=[cdmp_20230324133656], requested by (instance=1, osid=188856 (P200)), summary=[incident=1082420].

SMON: Restarting fast_start parallel rollback

Fri Mar 24 13:37:12 2023

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p000_188229.trc  (incident=1080530):

ORA-00600: internal error code, arguments: [17182], [0x7F3AB22ADBF8], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080530/xff1_p000_188229_i1080530.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Mar 24 13:37:12 2023

Dumping diagnostic data in directory=[cdmp_20230324133712], requested by (instance=1, osid=188229 (P000)), summary=[incident=1080530].

Fri Mar 24 13:37:24 2023

Block recovery from logseq 40030, block 259 to scn 17199959182

Recovery of Online Redo Log: Thread 1 Group 2 Seq 40030 Reading mem 0

  Mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761

Block recovery completed at rba 40030.317.16, scn 4.20089999

Fri Mar 24 13:37:37 2023

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x97E8579, kghrst()+1835] [flags: 0x0, count: 1]

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p000_188229.trc  (incident=1080531):

ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []

ORA-00600: internal error code, arguments: [17182], [0x7F3AB22ADBF8], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080531/xff1_p000_188229_i1080531.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Mar 24 13:37:37 2023

Dumping diagnostic data in directory=[cdmp_20230324133737], requested by (instance=1, osid=188229 (P000)), summary=[incident=1080531].

Fri Mar 24 13:38:16 2023

SMON: slave died unexpectedly, downgrading to serial recovery

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_smon_188020.trc  (incident=1080418):

ORA-00600: internal error code, arguments: [17182], [0x7F9184B445C0], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080418/xff1_smon_188020_i1080418.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Block recovery from logseq 40030, block 259 to scn 17199959182

Recovery of Online Redo Log: Thread 1 Group 2 Seq 40030 Reading mem 0

  Mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761

Block recovery completed at rba 40030.317.16, scn 4.20089999

ORACLE Instance xff1 (pid = 56) - Error 600 encountered while recovering transaction (10, 26) on object 242112.

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_smon_188020.trc:

ORA-00600: internal error code, arguments: [17182], [0x7F9184B445C0], [], [], [], [], [], [], [], [], [], []

Fri Mar 24 13:38:17 2023

Dumping diagnostic data in directory=[cdmp_20230324133817], requested by (instance=1, osid=188020 (SMON)), summary=[incident=1080418].

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x97E8579, kghrst()+1835] [flags: 0x0, count: 1]

Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_smon_188020.trc  (incident=1080419):

ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []

ORA-00600: internal error code, arguments: [17182], [0x7F9184B445C0], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080419/xff1_smon_188020_i1080419.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Mar 24 13:38:20 2023

PMON (ospid: 187888): terminating the instance due to error 474

System state dump requested by (instance=1, osid=187888 (PMON)), summary=[abnormal instance termination].

System State dumped to trace file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_diag_187902_20230324133820.trc

Fri Mar 24 13:38:21 2023

ORA-1092 : opitsk aborting process

Dumping diagnostic data in directory=[cdmp_20230324133820], requested by (instance=1, osid=187888 (PMON)), summary=[abnormal instance termination].

Instance terminated by PMON, pid = 187888

这类的故障在多年前处理过几次
ORA-600 17182导致oracle异常
ORA-00600[17182],ORA-00600[25027],ORA-00600[kghfrempty:ds]故障处理
这个故障的原因是由于block逻辑损坏,实例无法正常做回滚恢复,从而异常.处理异常回滚问题,就可以规避掉数据库启动后一会儿就crash问题.

• ORA-600 17182导致oracle异常
• ORA-00600[17182],ORA-00600[25027],ORA-00600[kghfrempty:ds]故障处理
• ORA-07445 opiaba—绑定变量超过65535导致实例crash
• tab$异常被处理之后报ORA-600 13304故障处理
• 记录一次200T的数据库恢复经历
• 正常open库报ORA-600 2662,ORA-600 4097错误
• Patch SCN工具快速解决ORA-600 2662问题
• tab$被恶意删除sys用户之外记录
• Oracle 19c故障恢复
• Exception [type: SIGSEGV, Address not mapped to object] [] [ kgegpa()+36]
• 又一例ORA-600 kcratr_nab_less_than_odr
• ORA-00600 kcratr_scan_rc