oracle alert日誌檔案報錯ORA-27302: failure occurred at: skgpspawn3

Solution

1- 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 should be 28 GB Instead of 17 GB

2- We can also try to increase physical memory, if possible.

3- In Unix Platforms , The user limits for user oracle should be checked , using the "ulimit -a " command.

4- We should also check memory parameters in the pfile/spfile that may add more load to the memory consumption on the server. For example setting the following parameters can add more overhead to memory consumption

-lock_sga=true
- db_keep_cache_size=

[@more@]Database Cannot Start Due to Lack of Memory [ID 560309.1]