Re: ORA-27146 on init.ora PROCESSES

#1

Billy Verreynne <vslabs (AT) onwe (DOT) co.za> schreef in berichtnieuws
1a75df45.0307100151.9305c69 (AT) pos...OT) google.com...

Quote:

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: ORA-27146 on init.ora PROCESSES

comp.databases.oracle.server comp.databases.oracle.server

Re: ORA-27146 on init.ora PROCESSES - 07-10-2003 , 11:46 AM