Durante a coleta de estatística do dicionário de dados do banco de dados, foi apresentado o erro:
ORA-27300: OS system dependent operation:fork failed with status: 12
Verificando o arquivo alert.log do banco de dados, encontramos as seguintes informações:
Process startup failed, error stack:
Errors in file
/u01/app/oracle/diag/rdbms/db_01/db_01/trace/db_01_psp0_20906206.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
Mon Sep 12 16:56:30 2016
Process J008 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/db_01/db_01/trace/db_01_cjq0_17432706.trc:
Process startup failed, error stack:
Errors in file
/u01/app/oracle/diag/rdbms/db_01/db_01/trace/db_01_psp0_20906206.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
Process J008 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/db_01/db_01/trace/db_01_cjq0_17432706.trc:
Process startup failed, error stack:
Errors in file
/u01/app/oracle/diag/rdbms/db_01/db_01/trace/db_01_psp0_20906206.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
Process J008 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/db_01/db_01/trace/db_01_cjq0_17432706.trc:
Mon Sep 12 16:56:40 2016
Este erro pode ocorrer em diversos momentos, dependendo da atividade do banco de dados.
Neste caso, o erro ocorreu durante a coleta de estatística do dicionário de dados do banco.
Causa:
Falta de espaço de swap no servidor.
Solução:
Aumentar a área de swap do banco de dados.