Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: skgpspawn failed:category

Re: skgpspawn failed:category

From: Hans.Wijte <Hans.Wijte_at_mail.ing.nl>
Date: 13 Mar 2006 05:21:04 -0800
Message-ID: <1142256064.490047.198020@j33g2000cwa.googlegroups.com>

parthpintoo_at_gmail.com wrote:
> i got this error in my alert.log. I am not able to understand what is
> this for......
>
> skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc =
> skgpspawn3
> skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc =
> skgpspawn3
> skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc =
> skgpspawn3
> skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc =
> skgpspawn3
>
> Can anyone help me ......

If you are running Oracle8i in Shared server mode then the following Metalink note might be of significance to you :

Subject: MTS:Shared Servers (Dispatchers) Fail to Start with ORA-27143 & ORA-27142 Errors
  Doc ID: Note:114279.1 Type: PROBLEM
  Last Revision Date: 21-OCT-2005 Status: PUBLISHED

Problem:


You are running Oracle8i with Multi-Threaded Server (MTS) enabled and intermittently receive the following error messages in the alert.log:

  skgpspawn failed:category = 27143, depinfo = 24, op = pipe, loc = skgpspawn2
  failed to start dispatcher 'D017' for network '(ADDRESS=(PARTIAL=YES)(PROTOCOL=i
  pc))', oer=27143

  skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
  failed to start multi-threaded server 'S066', oer=27142

You are unable to spawn shared servers (dispatchers).

You may also receive the following error when you connect to the database:

  TNS-12540 "TNS:internal limit restriction exceeded"

Solution:


  o Increase swap or memory,

--OR--

  o Reduce the number of shared servers (dispatchers) that can be started.

Note: If you are running on Unixware and Oracle 8.1.5, apply the patch

      for Bug Number 1003255. This patch fixes a problem with excessive

      memory use by shadow processes.

Explanation:


When you are running MTS and more shared servers need to be started, they
are automatically started up to the number of max servers specified in the
init.ora file.

This problem is occurring because you are running out of resources on your machine that are required for the servers to startup.

The error messages:

  skgpspawn failed:category = 27143, depinfo = 24, op = pipe, loc = skgpspawn2
  skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3

indicate that you are failing to spawn a shared server. The errors translate to:

  ORA-27143 "OS system call failure"
  ORA-27142 "could not create new process"

The operating system call that is failing is also in the error message:

  op = pipe
  op = fork

So the operating system calls pipe() and fork() are failing, and this is
usually caused by a lack of system resources.

Therefore, because there is a lack of memory and swap available on the system, this is causing the operating system calls pipe() and fork() to fail. When these calls fail, the shared servers are unable to start.

References:


Bug Number 1003255.
Additional Search Words:


7445 600 FT Received on Mon Mar 13 2006 - 07:21:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US