huziaa

0 积分	1 好友	7 主题

发消息

[升级] oracle core dump 分析

1^#

发表于 2013-12-12 08:31:20 | 查看: 7570| 回复: 5

环境：AIX 6.1 oracle r11.1.0.7 RAC 裸设备

前几天，系统由于宕机，领导要求追查问题的原因：

1、查看系统报错：

BCD520FF 0918160313 T H fcs1          ATTACHED SCSI TARGET DEVICE ERROR
[oraprod@db01 archivelog ]$ errpt | more
IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION
A924A5FC 1211125013 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED
A924A5FC 1211114313 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED
A924A5FC 1211104613 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED
A924A5FC 1210135613 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED
A924A5FC 1209165313 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED
A924A5FC 1209110013 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED
A924A5FC 1206120513 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED
A924A5FC 1206100813 P S SYSPROC       SOFTWARE PROGRAM ABNORMALLY TERMINATED

2、第二部看到错误是由于oracle引起的，但是指向一个core文件。

[oraprod@db01 archivelog ]$ errpt -a A924A5FC |more
---------------------------------------------------------------------------
LABEL:       CORE_DUMP
IDENTIFIER:    A924A5FC

Date/Time:    Wed Dec 11 12:50:09 GMT+08:00 2013
Sequence Number: 15045
Machine Id:    00CCF9944C00
Node Id:       db01
Class:          S
Type:          PERM
WPAR:          Global
Resource Name: SYSPROC

Description
SOFTWARE PROGRAM ABNORMALLY TERMINATED

Probable Causes
SOFTWARE PROGRAM

User Causes
USER GENERATED SIGNAL

      Recommended Actions
      CORRECT THEN RETRY

Failure Causes
SOFTWARE PROGRAM

      Recommended Actions
      RERUN THE APPLICATION PROGRAM
      IF PROBLEM PERSISTS THEN DO THE FOLLOWING
      CONTACT APPROPRIATE SERVICE REPRESENTATIVE

Detail Data
SIGNAL NUMBER
         6
USER'S PROCESS ID:
            5026004
FILE SYSTEM SERIAL NUMBER
      15
INODE NUMBER
   1983485
CORE FILE NAME
/u01/PRODDB/admin/diag/rdbms/prod/PROD1/cdump/core_5026004/core
PROGRAM NAME
oracle
STACK EXECUTION DISABLED
         0
COME FROM ADDRESS REGISTER
sskgmcrea 0

PROCESSOR ID
  hw_fru_id: 6
  hw_cpu_id: 13

ADDITIONAL INFORMATION
skgdbgcra 224
??
ksdbgcra 3D0

分享0