ORA-27302: failure occurred at: skgpspawn3
来源:互联网 发布:matlab机器人仿真软件 编辑:程序博客网 时间:2024/05/17 02:10
: Doc ID: Note:560309.1
Applies to:
OracleServer- Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.
Symptoms
The database can not start up due to the following errors:
Errors in file …….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
……
Cause
This issue is mainly caused by lack of memory / swap. Checking the memory configuration on the server, we have found the following:
Total Physical Memory 38912 MB
Swap: Max Size 17664 MiB
So, RAM is 38 GB, SWAP space is only 17 GB
Solution
-We should increase the server swap space (paging space) . The general rule of thumb is that swap space should be:
RAM SWAP
1GB to 2GB 1.5 times RAM
> 2GB and <= 8GB 1 times RAM
> 8GB .75 times RAM
So in our case, the recommended swap space is @28 GB .
We can also try to increase physical memory, if possible.
We should also check the ulimits for Oracle user.:
memory - unlimited
data - unlimited
cpu - unlimited
stack - at least 32768
nofile - OS dependent
We should also check memory parameters in the pfile/spfile that add more load to the memory consumption on the server. In our issue, we found these settings which added more pressure to the memory:
-lock_sga=true
-large db_keep_cache_size=14000m.
f,检查服务器10.10.10.100上的物理内存
Total Physical Memory 8GB
Swap: 8GB
应该正常
g,检查交换空间
lsps –a
size 8GB used% 69%
h,使用smitty chps命令添加4GB交换空间,至此,客户端可以正常连接数据库
- ORA-27302: failure occurred at: skgpspawn3
- ORA-27302: failure occurred at: skgpspawn3 可能的原因及处理
- ORA-27300 ORA-27301 ORA-27302: failure occurred at: skgpalive1
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ORA-00604 error occurred at recursive SQL level
- ORA-00604 error occurred at recursive SQL level string
- ORA-12170: TNS:Connect timeout occurred ORA-06512: at "SYS.DBMS_SNAPSHOT"
- ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found weblogic
- 案例学习Oracle错误: ORA-00604 error occurred at recursive SQL lev
- myeclipse连接oracle数据库问题:ORA-00604: error occurred at recursive SQL level 1
- java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
- myeclipse连接oracle数据库问题:ORA-00604: error occurred at recursive SQL level 1 .
- ORA-00604: error occurred at recursive SQL level 1 ORA-12705: invalid or unknown NLS parameter value
- ORA-00604: error occurred at recursive SQL level 1 ORA-00054: resource busy and acquire with NOWAIT
- ASIHTTPRequest "A connection failure occurred" error
- ASIHTTPRequest "A connection failure occurred" error
- ASIHTTPRequest "A connection failure occurred" error
- 心得
- javascript封装的类似java List类
- linux驱动开发 主设备号与次设备号
- 骨灰级泡妞高手白皮书之升级版
- 矩阵运算库Armadillo,Eigen,MATCOM在windows+vs2010环境下的安装和测评
- ORA-27302: failure occurred at: skgpspawn3
- 一步一步学好Linux开发之Coredump故障分析
- 软件bug定义
- Itween 贝塞尔曲线(一)
- 【笔试&面试】列举你所知道的
- css实现三角形 圆形
- Exercises 4.1 E2
- 一步一步学好Linux开发之Makefile工程管理
- E7