Possible causes and solutions for ORA-27302: failure occurred at: skgpspawn3

Possible causes and solutions for ORA-27302: failure occurred at: skgpspawn3

Symptom:

Mon May 26 07:08:58 GMT + 08:00 2014 Process startup failed, error stack:
Mon May 26 07:08:58 GMT + 08:00 2014 Errors in file/oracle/app/admin/oracle10/bdump/oracle10_1_psp0_7733326.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

Check the local disk and storage space according to the error message. No exception is found.

Solution:

Mos :( Document ID 560309.1)

1. The root cause is that the swap space (paging space) settings are unreasonable.

Configure the parameters correctly:

RAM SWAP
1 Gbit/s to 2 Gbit/s 1.5 times RAM
> 2 GB and <= 8 GB 1 times RAM
> 8 GB 0.75 times RAM

In 11.2, it is:
RAM SWAP
1 GB to 2 GB 1.5 times RAM
> 2 GB and <= 16 GB 1 times RAM
> 16 GB 16 GB RAM

2. In addition, pay attention to whether spfile contains such memory parameters:

Lock_sga = true
-Db_keep_cache_size = <High Value>

3. Alternatively, the physical memory of the system may be insufficient.

4. Of course, some parameter settings pages restricted by the user's environment variables will cause this problem. You can use this command to view them: ulimit-

Zookeeper