"unable to spawn jobq slave process" in alert.log
511057Apr 16 2007 — edited May 9 2007I had these errors in my alert.log Sunday morning right after the oracle export pump. It had detail in two trace files
ORA-00610: Internal error code
ORA-00610: Internal error code
Died during process startup with error 447 (seq=94168)
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
and
Dumping diagnostic information for J000:
OS pid = 815310
loadavg : 0.20 0.29 0.39
swap info: free_mem = 0.00M rsv = 24.50M
alloc = 2489.02M avail = 6272.00M swap_free = 3782.98M
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
240001 A oracle 815310 1 1 60 20 10682400 87756 01:34:44 - 0:00 ora_j000_BAAN
open: The file access permissions do not allow the specified action.
procstack: 815310 is not a process
From several online informations I found, it seems that there is a problem of memory in my Oracle 10g R2 (10.2.0.1) on AIX5.3L. The server has 4 G memory, 4 CPU. I allocated 1904 M for the SGA, 512M for PGA.
How do I handle this problem? It happened before but not quite often.