analyze core_dump

[MoreFeo]

Hi, we're running AIX 5.3 TL04 and oracle 10g. From time to time oracle gives a core like this:

LABEL:          CORE_DUMP
IDENTIFIER:     A63BEB70

Date/Time:       Mon Jun 18 13:12:00 DFT 2007
Sequence Number: 1029
Machine Id:      00CEEDBD4C00
Node Id:         oracle_srv
Class:           S
Type:            PERM
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:
                622650
FILE SYSTEM SERIAL NUMBER
          11
INODE NUMBER
       32778
PROCESSOR ID
           4
CORE FILE NAME
/mfs01/app/oracle/admin/P0PR/cdump/core_622650/core
PROGRAM NAME
oracle
STACK EXECUTION DISABLED
           0
ADDITIONAL INFORMATION
slcra 3EC
??
ssexhd 348
??

Symptom Data
REPORTABLE
1
INTERNAL ERROR
0
SYMPTOM CODE
PCSS/SPI2 FLDS/oracle SIG/6 FLDS/slcra VALU/3ec

How can I analyze this core? Searching a bit I've found adb and dbx command, but not sure if they'll do it and how to use them.

Helps.

 

[khalidaaa]

Oh yeah i do get these annoying core dumps from the oracle 10g!!!! But never find any answer form our DBAs so i just ignore them till something really bad happens and then they have ot reply on what they are doing with the system!

LABEL:          CORE_DUMP
IDENTIFIER:     A63BEB70

Date/Time:       Mon Jun 18 16:01:45 SAUST 2007
Sequence Number: 1756
Machine Id:      00C5C1EB4C00
Node Id:         oraserv
Class:           S
Type:            PERM
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
          11
USER'S PROCESS ID:
                794840
FILE SYSTEM SERIAL NUMBER
          12
INODE NUMBER
           2
PROCESSOR ID
           0
CORE FILE NAME
/ora0/app/oracle/core
PROGRAM NAME
opmn
STACK EXECUTION DISABLED
           0
ADDITIONAL INFORMATION
strlen 98
??
Unable to generate symptom string.

Regards,
Khalid

 

[MoreFeo]

The problem is that when this cores happens it starts paging up to 100% and our server hangs, so we need to know where is the problem and how to fix it.

 

[khalidaaa]

I would suggest you contact oracle and send them the core file! That's the best solution to avoid having the ball in your pitch

Regards,
Khalid