Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Error skgpspawn.....Possible cause/solution

Rita C Workman
Honored Contributor

Oracle Error skgpspawn.....Possible cause/solution

Just thought I'd post this, because I have been looking for a resolution to this today.

Loaded patches yesterday on my Production box (yes I loaded them on Dev box first a week ago, with no issues)...but kept getting our database clobbered with zombies till it fell with :

failed to restart multi-threaded.. skgpspawn3 ....ORA-0600 errors

A really sharp HP guy (Ed Jones) suggested checking the parms. Even though I hadn't made any kernel changes with the patch load...I checked and sure enough "maxuprc & shmmax" dropped back to default values. Both are dynamic so they were changed immediately.

Possible cause....the system file had somehow gotten out of whack, so when patches were loaded and kernel rebuilt it used a system file that did not have these parms values contained in it, thus causing them to drop back to default values.

Hope this helps somebody who maybe hits this situation..

Rgrds,
Rita

....No Postings Necessary...This was just informational for Forum Users ! ..
12 REPLIES
Uday_S_Ankolekar
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

Just curious, which patch(es)could have caused this. Would you mind shring this with forum??

-USA..
Good Luck..
Ross Zubritski
Trusted Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

Rita,

Please provide patches applied.

Thanks in advance.

RZ
Patrick Wallek
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

Hi Rita,

Sounds like you had quite fun Sunday. :)

I gather that this was on an 11i box?

Patrick
Steven E. Protter
Exalted Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

It must be 11i because of the dynamic parameters.

I would like to know the patch set as well, though I agree probably the system file was messed up prior to installation.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Rita C Workman
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

Ask and you shall receive....

Rgrds,
Rita
Ross Zubritski
Trusted Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

Ouch, definately a long weekend.

Thanks

RZ
Rita C Workman
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

Forgot to mention..

Yes the box is 11i/64bit.

The patches probably did not cause it....just pointed it out. More than likely it was the system file that was missing the values for these two parms...so when kernel reformed, these dropped back to default value.

Rgrds,
Rita
Indira Aramandla
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

Hi,

It looks like you are unable to spawn shared servers (dispatchers).

Solution:
1. Increase swap or memory,

--OR--

2. 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:

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.
Never give up, Keep Trying
Jeff Schussele
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

I would add that we've had Dec '02 patches do the following to us recently...

1) Cause a rewrite of the ftp command line in /etc/inetd.conf - caused the -a parm to be added w/o the benefit of having the /etc/ftpd/ftpaccess file - caused ftp denials.

2) Caused ntpd to fail at first boot after patch application. You see this in syslog...IF you're watching.

We're still tracking both these down. We have a sneaking suspicion that both have to do with patches NOT included in QPK or HWE bundles, but rather in "recommended" or security related patch bundles which MAY be entirely unique to us...but never say never.

rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Khalid A. Al-Tayaran
Valued Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution


We had a similar problem. We had to re-link all oracle libraries to bring up oracle again... this only happend in production not in development.....
Yogeeraj_1
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

why use MTS in development?
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Rita C Workman
Honored Contributor

Re: Oracle Error skgpspawn.....Possible cause/solution

That you all for the great responses/suggestions on what to do.

But it was already fixed.
Please go back and read all of the beginning posts.

I posted as information for anyone else who might run into this in the future (as I didn't much in the Forums on this when I did a Search). As with any patch process, 'stuff happens'.

Hope other benefit by the information here..

Rgrds,
Rita

...Consider this post closed...