- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle Error skgpspawn.....Possible cause/solution
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 10:38 AM
тАО05-19-2003 10:38 AM
Oracle Error skgpspawn.....Possible cause/solution
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 ! ..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 11:01 AM
тАО05-19-2003 11:01 AM
Re: Oracle Error skgpspawn.....Possible cause/solution
-USA..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 11:06 AM
тАО05-19-2003 11:06 AM
Re: Oracle Error skgpspawn.....Possible cause/solution
Please provide patches applied.
Thanks in advance.
RZ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 11:15 AM
тАО05-19-2003 11:15 AM
Re: Oracle Error skgpspawn.....Possible cause/solution
Sounds like you had quite fun Sunday. :)
I gather that this was on an 11i box?
Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 11:30 AM
тАО05-19-2003 11:30 AM
Re: Oracle Error skgpspawn.....Possible cause/solution
I would like to know the patch set as well, though I agree probably the system file was messed up prior to installation.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 11:54 AM
тАО05-19-2003 11:54 AM
Re: Oracle Error skgpspawn.....Possible cause/solution
Rgrds,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 11:57 AM
тАО05-19-2003 11:57 AM
Re: Oracle Error skgpspawn.....Possible cause/solution
Thanks
RZ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 12:00 PM
тАО05-19-2003 12:00 PM
Re: Oracle Error skgpspawn.....Possible cause/solution
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 07:52 PM
тАО05-19-2003 07:52 PM
Re: Oracle Error skgpspawn.....Possible cause/solution
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2003 08:03 PM
тАО05-19-2003 08:03 PM
Re: Oracle Error skgpspawn.....Possible cause/solution
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