Re: ORA-27146 on init.ora PROCESSES

Billy Verreynne <vslabs_at_onwe.co.za> schreef in berichtnieuws 1a75df45.0307100151.9305c69_at_posting.google.com...
| HP-UX 11 B2. Oracle 8.1.7.4
|
| I can not get the PROCESSES to beyond 50 in the init.ora without
| running into this on startup:
|
| 27146, 0000, "post/wait initialization failed"
| // *Cause: OS system call failed
| // *Action: check errno and contact Oracle Support
|
| I'm expecting to see a HP-UX error, but nothing (including alert log).
| I'm assuming this must be some kernel limitation. Besides, processes
| is set to 200 on another HP-UX box.
|
| Unix sysadmin is on leave. Any ideas where I need to scratch to fix?
| Have SAM without a guidance system - okay, a bad pun. No too mention
| that this will likely raise an alarm in some computer in somce obscure
| DoD/NSA basement ;-)
|
| While on the topic of HP-UX..
|
| Can the SGA be locked in memory (what HP-UX settings are needed)? And
| is it worth only when there is heavy paging?
|
| The usual pointers, blondes and Bavarian beer will be appreciated.
| Thanks.
|
| --
| Billy

Really looks like a semaphores kernel parameter that is set too low. Read the Oracle Installation Guide for HP-UX. In the "prepare to install" chapter the requirements for kernel settings are on one page. You need to know the sum of all processes parameter values of all databases that will run on that box. Each process requires one semaphore. Semaphores are allocated in sets. Kernel params sets the set size, maximum sets and the total number of semaphores on the system. Don't ask me for there names, see the doc. The ora error occurs when the starting instance can't get enough semaphores from the os.
A workaround for the short term could be to shutdown other databases on the node or reduce processes (temporarely) for these databases. Can't help you with SAM. We have excellent Unix administrators so there is no need for me to get knowledge of that tool. Maybe you can find something on the HP web site? Received on Thu Jul 10 2003 - 11:46:09 CDT