本人负责一个政府办公自动化系统
数据库在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时间,
全部失败,问题依然的存在,
数据库在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时间,
全部失败,问题依然的存在,
解决方案 »
- 数据库迁移,Sql2008-Oracle10G 问题
- 如何避免SELECT xxx INTO xxx FROM 时产生NO_DATA_FOUND错误
- Oracle EBS的客户端和服务端之间的通信协议
- 关于sql语句的性能
- 谁能帮我看一下我写的存储过程,老是说有编译错误,可又不给出错误的具体地方?我找了半天也找不到。
- 新建数据库
- 关于行列转换问题
- 打开oracle 10g 出现这样的问题,求高手帮忙解决
- oracle 多表关联查询时 添加查询条件,查询速度变得极慢
- EXP问题求助
- oracle多表查询去重复
- 如何让oracle还原成刚安装完oracle的状态哈?之前不小心复制了一些sql现在oracle出问题了想恢复成刚安装的状态!求大神解答,在线等人气伺候着!!!
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3问题找出来了,修改内核参数,发现网络有点问题,心跳有时候会掉,别踢出了实例。导致session突然变大,
还有内存的问题,内存太小啊,