RE: ORA-27146: post/wait initialization failed

From: <arul.kumar_at_bt.com>
Date: Tue, 23 Nov 2004 17:01:43 -0000
Message-ID: <83FC2D1BC95D884894735B11B562A41C08377AD8@i2km06-ukbr.domain1.systemhost.net>

I think you should consider increasing semmsl. Pl. refer below the = guidelines which I took sometime back from Metalink.

Thanks,
Arul.

Common Unix Kernel Parameter Definitions=20

The following Kernel Parameters tend to be generic across most Unix = platforms. However, their names may be different on your platform. = Consult your Installation and Configuration Guide (ICG) for the exact = names.=20

maxfiles - Soft file limit per process.=20 maxuprc - Maximum number of simultaneous user processes per userid.=20 nfile - Maximum number of simultaneously open files systemwide at any = given time.=20
nproc - Maximum number of processes that can exist simultaneously in the = system.=20

shmmax - The maximum size(in bytes) of a single shared memory segment.=20
shmmin - The minimum size(in bytes) of a single shared memory segment.=20
shmmni - The number of shared memory identifiers.=20
shmseg - The maximum number of shared memory segments that can be =

attached by a process.=20
semmns - The number of semaphores in the system.=20 semmni - The number of semaphore set identifiers in the system; = determines the number of semaphore sets that can be created at any one = time.=20

**semmsl - The maximum number of sempahores that can be in one semaphore = set. **It should be same size as maximum number of Oracle processes. **

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ignizio, Richard Sent: 23 November 2004 15:38
To: 'Oracle-L_at_FreeLists.org'
Subject: ORA-27146: post/wait initialization failed

I recieved this error when I bumped up the processes to 500 from 250. = There
is one other database on the server with processes set a 200. The /etc/system parameters are:

set semsys:seminfo_semmap=3D0x13d
set semsys:seminfo_semmnu=3D0x13d
set semsys:seminfo_semmns=3D1317
set semsys:seminfo_semmni=3D312
set semsys:seminfo_semmsl=3D429

I set the processes to 300 and the database was able to start.=20

So with that in mind going by Oracle's formula for setting semmns, (500 = +
200) + 500 + (10 *2) =3D 1220. So techinally I should not be running = into this
error based on this criteria. Does Oracle also look at semmsl or semmni? This is a Sun Solaris server.

Thanks in advance,
Rich=20

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 23 2004 - 13:44:58 CST