求助!oracle的日志发现ORA-07445错误!

[复制链接]
查看11 | 回复5 | 2013-2-25 14:51:24 | 显示全部楼层 |阅读模式
alter.log:
Thu Mar 28 15:25:31 2013Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x841BFE3, __PGOSF520_upduaw()+3019] [flags: 0x0, count: 1]Errors in file /oracle/diag/rdbms/acms/acms/trace/acms_ora_23431.trc(incident=8937):ORA-07445: 出现异常错误: 核心转储 [upduaw()+3019] [SIGSEGV] [ADDR:0x0] [PC:0x841BFE3] [Address not mapped to object] []Thu Mar 28 15:25:32 2013Sweep [inc][8937]: completed
cms40_ora_23431.trc:Trace file /oracle/diag/rdbms/acms/acms/trace/acms_ora_23431.trcOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORACLE_HOME = /oracle/product/11.2.0/db_1System name:LinuxNode name:lingmahaiRelease:2.6.18-194.el5Version:#1 SMP Fri Apr 2 14:58:14 EDT 2010Machine:x86_64Instance name: acmsRedo thread mounted by this instance: 1Oracle process number: 36Unix process pid: 23431, image: oracle@lingmahai
*** 2013-03-28 15:25:31.748*** SESSION ID

132.50817) 2013-03-28 15:25:31.748*** CLIENT ID

) 2013-03-28 15:25:31.748*** SERVICE NAME

SYS$USERS) 2013-03-28 15:25:31.748*** MODULE NAME

JDBC Thin Client) 2013-03-28 15:25:31.748*** ACTION NAME

) 2013-03-28 15:25:31.748 --------Dumping Sorted Master Trigger List --------Trigger Owner : ACMSUSERTrigger Name : TR_PAGELAYOUTTrigger Owner : ACMSUSERTrigger Name : T_PAGELAYOUT_UPDATE--------Dumping Trigger Sublists -------- trigger sublist 0 : trigger sublist 1 :Trigger Owner : ACMSUSERTrigger Name : TR_PAGELAYOUTTrigger Owner : ACMSUSERTrigger Name : T_PAGELAYOUT_UPDATE trigger sublist 2 : trigger sublist 3 : trigger sublist 4 :
*** 2013-03-28 15:25:31.753Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x841BFE3, __PGOSF520_upduaw()+3019] [flags: 0x0, count: 1]DDE: Problem Key 'ORA 7445 [upduaw()+3019]' was flood controlled (0x6) (incident: 8937)ORA-07445: 出现异常错误: 核心转储 [upduaw()+3019] [SIGSEGV] [ADDR:0x0] [PC:0x841BFE3] [Address not mapped to object] []ssexhd: crashing the process...Shadow_Core_Dump = PARTIAL
请教下ORA-07445这个问题是因为什么产生的,应该怎么去解决?


回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
BUG
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
ORA-07445的原因比ORA-00600还复杂,可以用oradebug跟踪一下。
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
[upduaw()+3019],没见过这个函数,到MOS上查查吧。
07445一般是由于OS的原因触发的BUG。
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
多数是bug
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
碰见过几次,从没有真正解决过,只是打个补丁,期望别再出现
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行