ORA-609：疑似MEMORY_TARGET设置过大导致的宕机

最新推荐文章于 2021-08-12 09:42:04 发布

原创最新推荐文章于 2021-08-12 09:42:04 发布 · 3.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#database #oracle #宕机 #内存管理

RAC 专栏收录该内容

21 篇文章

订阅专栏

本文记录了一次数据库频繁出现ORA-609错误导致宕机的现象及解决方案。通过对内存设置的调整，成功避免了系统资源耗尽引发的故障。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-609：疑似MEMORY_TARGET设置过大导致的宕机

现象：
客户的数据库最近发生好几次忽然宕机事件，查看alert日志：
Thu Oct 10 10:47:50 2013
ORA-609 : opiodr aborting process unknown ospid (834_47932399713424)
Thu Oct 10 10:47:50 2013
ORA-609 : opiodr aborting process unknown ospid (740_47613956914320)
Thu Oct 10 10:47:53 2013
ORA-609 : opiodr aborting process unknown ospid (755_47556191542416)
Thu Oct 10 10:47:53 2013
ORA-609 : opiodr aborting process unknown ospid (761_47545590688912)
Thu Oct 10 10:47:54 2013
ORA-609 : opiodr aborting process unknown ospid (859_47653507185808)
Thu Oct 10 10:47:58 2013
ORA-609 : opiodr aborting process unknown ospid (904_47121713061008)
Thu Oct 10 10:48:08 2013
ORA-609 : opiodr aborting process unknown ospid (918_47924605709456)
Thu Oct 10 10:48:16 2013
ORA-609 : opiodr aborting process unknown ospid (965_46996288695440)
Thu Oct 10 10:48:16 2013
ORA-609 : opiodr aborting process unknown ospid (984_47202090368144)
Thu Oct 10 10:49:06 2013
ORA-609 : opiodr aborting process unknown ospid (1103_47027913133200)
Thu Oct 10 10:49:08 2013
Thu Oct 10 10:49:08 2013
ORA-609 : opiodr aborting process unknown ospid (1064_47991325715600)
ORA-609 : opiodr aborting process unknown ospid (1150_47885260754064)
Thu Oct 10 10:50:02 2013
Process W000 died, see its trace file
Thu Oct 10 10:50:17 2013
Process W001 died, see its trace file
Thu Oct 10 10:54:19 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:54:31 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:54:43 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:54:55 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:55:07 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:55:19 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 10:55:31 2013
Process W000 died, see its trace file
Process W000 died, see its trace file
Process W000 died, see its trace file
Thu Oct 10 11:02:06 2013
Thread 2 advanced to log sequence 18269
Current log# 15 seq# 18269 mem# 0: +UNIDG/uni/onlinelog/group_15.295.796513629
Thu Oct 10 11:02:08 2013
SUCCESS: diskgroup UNIDG was mounted
Thu Oct 10 11:02:18 2013
SUCCESS: diskgroup UNIDG was dismounted
Thu Oct 10 11:03:40 2013
Process m001 died, see its trace file
Thu Oct 10 11:04:23 2013
Process m001 died, see its trace file

分析：
查看启动时的参数设置，发现客户的系统启用了自动内存管理：
memory_target = 21G <-------------Automatic Memory Management feature is used.
free -g查看内存为23G
怀疑主机资源耗尽导致系统宕机，建议客户memory_target设置为16-18G。
调小memort_target之后，之前的自动宕机现象消失。

附：分析了如下日志。
$CRS_HOME/log/<nodename>/*.log
$CRS_HOME/log/<nodename>/crsd/*.log
$CRS_HOME/log/<nodename>/cssd/*.log
/etc/oracle/oprocd/*.log.* or /var/opt/oracle/oprocd/*.log.*