记一次ORA-07445[opiaba()+639],ORA-00600[17147]数据库异常中止故障案例

故障描述:

数据库版本:11.2.0.3.0(单实例) 操作系统版本:redhat linux 6.5

数据库在凌晨3点自动关闭,同事发现故障后,立马手动startup开启了数据库,开启后数据库运行正常。

故障时数据库alert日志如下:

Wed Oct 10 02:51:47 2018
Thread 1 advanced to log sequence 75978 (LGWR switch)
  Current log# 5 seq# 75978 mem# 0: /u01/app/oracle/oradata/XXX/redo05.log
Wed Oct 10 02:51:52 2018
Archived Log entry 149289 added for thread 1 sequence 75977 ID 0xbca5e435 dest 1:
Wed Oct 10 03:00:05 2018
ALTER SYSTEM ARCHIVE LOG
Wed Oct 10 03:00:05 2018
Thread 1 advanced to log sequence 75979 (LGWR switch)
  Current log# 2 seq# 75979 mem# 0: /u01/app/oracle/oradata/XXX/redo02.log
Archived Log entry 149291 added for thread 1 sequence 75978 ID 0xbca5e435 dest 1:
Wed Oct 10 03:06:34 2018
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x17E86CF, opiaba()+639] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/XXX1/XXX/trace/XXX_ora_48752.trc  (incident=113956):
ORA-07445: 出现异常错误: 核心转储 [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x17E86CF] [SI_KERNEL(general_protection)] []
Incident details in: /u01/app/oracle/diag/rdbms/XXX1/XXX/incident/incdir_113956/XXX_ora_48752_i113956.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Oct 10 03:06:48 2018
Dumping diagnostic data in directory=[cdmp_20181010030648], requested by (instance=1, osid=48752), summary=[incident=113956].
Wed Oct 10 03:12:03 2018
Thread 1 advanced to log sequence 75980 (LGWR switch)
  Current log# 6 seq# 75980 mem# 0: /u01/app/oracle/oradata/XXX/redo06.log
Wed Oct 10 03:12:15 2018
Archived Log entry 149293 added for thread 1 sequence 75979 ID 0xbca5e435 dest 1:
Wed Oct 10 03:17:09 2018
Process 0x0x26c1c99fc8 appears to be hung while dumping
Current time = 1550270160, process death time = 1550208043 interval = 60000
Attempting to kill process 0x0x26c1c99fc8 with OS pid = 48752
OSD kill succeeded for process 0x26c1c99fc8
Errors in file /u01/app/oracle/diag/rdbms/XXX1/XXX/trace/XXX_pmon_4152.trc  (incident=112148):
ORA-00600: internal error code, arguments: [17147], [0x2581886088], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/XXX1/XXX/incident/incdir_112148/XXX_pmon_4152_i
  • 2
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值