怎么样解决session不释放,导致内存不足,数据库挂掉的问题
本人负责一个政府办公自动化系统
数据库在hp-unix 安装了RAC ( 10.2.0.3),只要session会话没有及时的释放的话,数据库告警日记就会报内存空间不足,导致数据库挂掉,其中的一个实例offline
前段报 tns无法分发服务 等
告警日记如下:
rocess m000 died, see its trace file
Thu Apr 5 14:10:51 2012
ksvcreate: Process(m000) creation failed
Thu Apr 5 14:11:51 2012
Process startup failed, error stack:
Thu Apr 5 14:11:51 2012
Errors in file /oracle/app/oracle/admin/jtdb/bdump/jtdb1_psp0_5264.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Thu Apr 5 14:11:52 2012
Process m000 died, see its trace file
Thu Apr 5 14:11:52 2012
ksvcreate: Process(m000) creation failed
Thu Apr 5 14:12:53 2012
Process startup failed, error stack:
Thu Apr 5 14:12:53 2012
Errors in file /oracle/app/oracle/admin/jtdb/bdump/jtdb1_psp0_5264.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Thu Apr 5 14:12:54 2012
Process m001 died, see its trace file
Thu Apr 5 14:12:54 2012
其中想了好多解决方法:
服务器端设置了failover和LOAD_BALANCE
设置 prorfile 来监视用户session时间,
全部失败,问题依然的存在,