RE: ORA-27146: post/wait initialization failed
- From: <arul.kumar@xxxxxx>
- To: <richard.ignizio@xxxxxxxxxx>
- Date: Tue, 23 Nov 2004 17:01:43 -0000
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ignizio, Richard
Sent: 23 November 2004 15:38
To: 'Oracle-L@xxxxxxxxxxxxx'
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
