ORACLE在AIX中产生SOFTWARE PROGRAM ABNORMALLY TERMINATED警告原因

#errpt

#alter.log文件

Errors in file /zyhome/oracle/admin/ossdb1/udump/ossdb1_ora_1180032.trc:       从中可以查看到执行哪个sql产生的
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Mon Apr 15 17:30:40 2013
Errors in file /zyhome/oracle/admin/ossdb1/udump/ossdb1_ora_1053164.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []

 

数据库中发现如下错误

该错误的解决方案:ORA-07445[dbgrmqmqpk_query_pick_key()+0f88]

Dumpfile /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_579300/sgerp5_m000_7602504_i579300.trc

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/product/11.1.0/db_1

System name:    AIX

Node name:  sgerp5

Release:    1

Version:    6

Machine:    00C8F0564C00

Instance name: sgerp5

Redo thread mounted by this instance: 1

Oracle process number: 138

Unix process pid: 7602504, image: oracle@sgerp5 (m000)

 

*** 2012-05-11 03:52:35.200

*** SESSION ID:(752.5029) 2012-05-11 03:52:35.200

*** CLIENT ID:() 2012-05-11 03:52:35.200

*** SERVICE NAME:(SYS$BACKGROUND) 2012-05-11 03:52:35.200

*** MODULE NAME:(MMON_SLAVE) 2012-05-11 03:52:35.200

*** ACTION NAME:(Auto-Purge Slave Action) 2012-05-11 03:52:35.200

 

Dump continued fromfile: /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_m000_7602504.trc

ORA-07445: exception encountered: core dump [dbgrmqmqpk_query_pick_key()+0f88]

[SIGSEGV] [ADDR:0xB38F0000000049][PC:0x100213C08] [Address not mapped to object] []

errpt错误说明

在产生7445错误的同时观察aix系统错误日志发现SOFTWARE PROGRAM ABNORMALLY TERMINATED错误

sgerp5_[oracle]-->errpt -aj A924A5FC

---------------------------------------------------------------------------

LABEL:          CORE_DUMP

IDENTIFIER:     A924A5FC

 

Date/Time:       Fri May 11 03:52:55 BEIST 2012

Sequence Number: 471

Machine Id:      00C8F0564C00

Node Id:         sgerp5

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:

               7602504

FILE SYSTEM SERIAL NUMBER

          14

INODE NUMBER

           0      367648

CORE FILE NAME

/oracle/diag/rdbms/sgerp5/sgerp5/cdump/core_7602504/core

PROGRAM NAME

oracle

STACK EXECUTION DISABLED

           0

COME FROM ADDRESS REGISTER

sskgmcrea 0

 

PROCESSOR ID

  hw_fru_id: 1

  hw_cpu_id: 2

 

ADDITIONAL INFORMATION

skgdbgcra 224

??

ksdbgcra 3D0

ssexhd 978

??

 

Symptom Data

REPORTABLE

1

INTERNAL ERROR

0

SYMPTOM CODE

PCSS/SPI2FLDS/oracle SIG/6 FLDS/skgdbgcraVALU/224

错误原因

This error is logged when a software program abnormally ends and causes a core dump. Users might

not be exiting applications correctly, the system might have been shut downwhileusers were

workinginapplication, or the user's terminal might have locked up and the application stopped

1)这里也就是说如果oracle进程在aix机器上异常终止,并且产生了一个core dump文件,

  就会出现SOFTWARE PROGRAM ABNORMALLY TERMINATED警告信息

2)用户登录系统没有正常退出,而系统被关闭

3)用户强制终止一个一个lock,而导致进程停止

本次AIX日志警告原因:由于进程7602504异常终止(ORA-07445错误)并且产生了 /oracle/diag/rdbms/sgerp5/sgerp5/cdump/core_7602504/core dump 文件,从而有了AIX中的SOFTWARE PROGRAM ABNORMALLY TERMINATED警告信息

 

ORA-07445: exception encountered: core dump [] [] [] [] [] []
Current SQL statement for this session:
declare ret binary_integer; begin ret := PBSDE.DEBUG_LOOP; end;

 

源文档 <http://www.xifenfei.com/3133.html>