oracle skgxpcini1,ORA-27302: failure occurred at: skgpspawn3

ORA-27302: failure occurred at: skgpspawn3

类别：Oracle数据库   作者：码皇   来源：互联网   点击：

ORA-27302: failure occurred at: skgpspawn3Applies to:OracleServer- Enterprise Edition - Version: 10 2 0 1 to 10 2 0 3This problem can occur on any platform SymptomsThe database

ORA-27302: failure occurred at: skgpspawn3 Applies to:OracleServer- Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3This problem can occur on any platform.SymptomsThe database can not start up due to the following errors: Errors in file …….trc:……ORA-27300: OS system dependent operation:fork failed with status: 12ORA-27301: OS failure message: Not enough spaceORA-27302: failure occurred at: skgpspawn3……  CauseThis 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 MBSwap: Max Size 17664 MiBSo, 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                              SWAP1GB 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 - unlimiteddata       - unlimitedcpu        - unlimitedstack      - at least 32768nofile      - 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 8GBSwap: 8GB应该正常 g,检查交换空间lsps –asize 8GB  used% 69% h，使用smitty chps命令添加4GB交换空间，至此，客户端可以正常连接数据库

相关热词搜索：

ORA-27302: failure occurred