How can I do?

[Steven Sim Kok Leong]

Hi,

The formula for semmni and semmns by default is as follows:

semmni (NPROC*5)
semmns (SEMMNI*2)

Even though your nproc has been increased, your semmni did not follow the default formula for increase.

If you are using the default formula for semmns, a semmni of only 128 will result in an semmns of 256 only.

It does not explain why processes=800 works but not processes=1000, unless your semmns is more than 800 but less than 1000.

Remember also to check your shared memory and semaphore resources that they are properly released after a database is shutdown or after a failed database startup.

# ipcs -b -m
# ipcs -b -s

Hope this helps. Regards.

Steven Sim Kok Leong

[Wan Bo]

Hello everyone,you are so kind to help,thanks a lot. I will try these ways tomorrow, and make a reply in this.

rickman