Database Administration (MOSC)

MOSC Banner

HugePages_Rsvd异常升高,远远大于hugepages_total,数据库实例异常。

edited Apr 5, 2013 6:59AM in Database Administration (MOSC) 4 commentsAnswered
现象: 1、用sqlplus / as sysdba本地连接数据库,提示connect to an idle instance,已检查确认过环境变量以及$ORACLE_HOME/bin/oracle文件的权限没有问题。当用tns远程连接的时候提示ORA-01034: ORACLE not available
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 6520842
ORA-01034: ORACLE not available
提示内存不足,但是此时通过free命令可看到系统还剩余10GB以上的空闲内存,同时系统cache了接近20gb的内存。系统使用了hugepage
alert日志中无异常报错,手动kill掉j000进程,出现进程关闭后无法重启的报错,无其他信息。
最后通过kill pmon进程重启数据库后恢复

2、系统使用Hugepage,在数据库发生异常的时候
zzz ***Tue Feb 26 18:23:14 CST 2013
HugePages_Total: 15013
HugePages_Free: 70
HugePages_Rsvd: 18446744073709551615
Hugepagesize: 2048 kB

hugepages_rsvd远远大于hugepages_total,mos sr曾帮忙分析说是系统内核参数hugepages_rsvd异常后才导致的数据库异常

问题:
有没有朋友遇到过类似问题,由于没有买redhat系统支持,所以看看各位有没有相关的工具或者脚本能跟踪到hugepages_rsvd异常升高的问题。

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center