- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: error in alert log.
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
тАО02-28-2010 12:18 AM
тАО02-28-2010 12:18 AM
we are getting the below errors in the alert log and the application needs to be restarted because it hangs.
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
ORA-27303: additional information: skgpspawn5
Tue Feb 16 11:07:59 2010
Process q001 died, see its trace file
Tue Feb 16 11:07:59 2010
ksvcreate: Process(q001) creation failed
tail -20 alert_2K.log
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
ORA-27303: additional information: skgpspawn5
Tue Feb 16 11:07:47 2010
Process q001 died, see its trace file
Tue Feb 16 11:07:47 2010
ksvcreate: Process(q001) creation failed
Tue Feb 16 11:07:58 2010
Process startup failed, error stack:
Tue Feb 16 11:07:58 2010
Errors in file ...._psp0_22791.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
ORA-27303: additional information: skgpspawn5
Tue Feb 16 11:07:59 2010
Process q001 died, see its trace file
Tue Feb 16 11:07:59 2010
ksvcreate: Process(q001) creation failed
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2010 06:09 AM
тАО02-28-2010 06:09 AM
Re: error in alert log.
Check you /var/adm/syslog/syslog.com for more information. You may have to increase some kernel parameters such as nproc, maxuprcs, nfile, nflocks etc. Also check you memory and swap space utilization.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2010 02:51 PM
тАО02-28-2010 02:51 PM
Re: error in alert log.
Right, you want to do a "swapinfo -tam" at the same time as your heavy load, to be as accurate as possible.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2010 06:42 PM
тАО02-28-2010 06:42 PM
Re: error in alert log.
Plus check your memory usage when you trying to start the oracle.
BR,
Kapil+
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2010 10:50 PM
тАО02-28-2010 10:50 PM
Re: error in alert log.
Please read the following document related to recommended kernel parameters:
http://h21007.www2.hp.com/portal/download/files/unprot/database/HP3KOracle.ppt
Make the settings and then try to start again your instance. If still have problems, should check also oracle initialization parameters
Best regards,
Horia.
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2010 05:28 AM
тАО03-01-2010 05:28 AM
Re: error in alert log.
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 16384 380 16004 2% 0 - 1 /dev/vg00/lvol2
reserve - 16002 -16002
memory 15555 15247 308 98%
total 31939 31629 310 99% - 0 -
We have noticed that there is no swapping even when the memory reaches 100% utilization.
also changed nproc value. and have reduced the filecache_max/min to 5 & 3 % respectively.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2010 05:38 AM
тАО03-01-2010 05:38 AM
Re: error in alert log.
Around here, error 11 is EAGAIN, "No more
processes". I'd worry less about memory,
and more about a limit on process count. Of
course, the error code could be misleading.
> [...] also changed nproc value.
From what to what?
man ulimit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2010 05:45 AM
тАО03-01-2010 05:45 AM
Re: error in alert log.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2010 05:53 AM
тАО03-01-2010 05:53 AM
Re: error in alert log.
It seems that this bug is fixed on 10.2.0.3+.
What is your version of oracle?
Horia.
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2010 06:03 AM
тАО03-01-2010 06:03 AM
Re: error in alert log.
the problem occurs only when the swapinfo shows 100% utilization of memory.
ram and swap is 16GB each.
why is there no swapping.