本文档详细分析了AIX系统中遇到的SOFTWARE PROGRAM ABNORMALLY TERMINATED警告，该警告通常与Oracle进程异常终止并产生core dump文件有关。错误可能由多种原因引起，如用户未正确退出应用程序、系统意外关闭或用户强制终止进程。通过检查错误日志和核心转储文件，可以定位到具体的问题SQL语句，例如声明并执行DEBUG_LOOP的过程。
#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]
Dump file /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-0
最低0.47元/天 解锁文章
扫一扫
427
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
