ITPub博客

首页 > Linux操作系统 > Linux操作系统 > skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3

原创 Linux操作系统 作者:boyall111 时间:2011-04-25 20:44:01 0 删除 编辑

skgpspawn failed:category = 27142, depinfo = 11, p = fork, loc = skgpspawn3

skgpspawn failed:category = 27142, depinfo = 12, p = fork, loc = skgpspawn3

     在oracle 日志中可能会看到类似的信息,从整体来看是系统不足引起无法启动新

的进程。

    其中category = 27142 是指示出现了ora-27142错误

           depinfo=指示出错的资源原因

           p=Fork

         loc = skgpspawn3 无法spawn进程

depinfo=11 是内核限制,可以通过修改系统内核参数;

depinfo=12是资源不足限制,更多的出现在内存和SWAP不足。

 

Metalink 的 解释更全面;


MTS:Shared Servers (Dispatchers) Fail to Start with ORA-27143 & ORA-27142 Errors [ID 114279.1]

  Modified 21-OCT-2005     Type PROBLEM     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, p = pipe, loc = skgpspawn2  
  failed to start dispatcher 'D017' for network '(ADDRESS=(PARTIAL=YES)(PROTOCOL=i
  pc))', er=27143       

  skgpspawn failed:category = 27142, depinfo = 11, p = fork, loc = skgpspawn3  
  failed to start multi-threaded server 'S066', er=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, p = pipe, loc = skgpspawn2
  skgpspawn failed:category = 27142, depinfo = 11, p = 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:

  p = pipe
  p = 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
















Back to topBack to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/229689/viewspace-693702/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-03-03

  • 博文量
    15
  • 访问量
    19938