oracle core文件使用率,oracle core dump 分析 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusDat...

环境：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