number of processes

I want to use enterprise manager version 2.0.4 and for that use I need 200 processes.
1. Why?
2. What is the exact meaning of this parameter?
3. I tried to create a database with the processes parameter set to 200 and startup fails saying:
ORA-27146: post/wait initialization failed.
What else do I need to change inorder for that to work?
Who is Participating?
mshaikhConnect With a Mentor Commented:
If this is Solaris you can do the following. You will need root password to do this.

1.. Edit /etc/system
2.. Increase the value of
      set semsys: seminfo_semmns      ( you must increase this to solve your problem)
      set semsys: seminfo_semmsl       (this value is not so critical)
3.. Reboot the server.

If this not Solaris, you still need to increase these same kernel parameters (SEMMNS and/or SEMMSL) but the  method may be different.
1.. I don't know why 200 and not 100  or 300 ?
2.. This basically defines the max number of process that can run simultaneously that are owned by Oracle. It is inportant because, the connections that are made to the server spawn a seperate process for each connection in a dedicated server. Basically, higher this number more connection you can make simultaneously.
3..  What OS are you using?

If you are using Solaris then you have to make sure that the following kernel parameters are set with proper values:

SEMMNS: The number of semaphores per set. It should be at least
                the same size as the maximum number of Oracle

SEMMSL: The maximum number of semaphores that can be in one
               semaphore set. It should be the same size
               as the maximum number of Oracle processes.
wabby26Author Commented:
I set both to 200 and restarted the workstation (Solaris2.7).
Still I get the same error when starting the database. Maybe there is another thing to change?
Never miss a deadline with

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Those values are too low.
Try these:

set semsys: seminfo_semmns=5000
set semsys: seminfo_semmsl=275    
wabby26Author Commented:
set shmsys:shminfo_shmmax=268435455
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semmsl=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

These are my current parameters.
Try these. These should work.

set semsys:seminfo_semmni=512
set semsys:seminfo_semmsi=512
set semsys:seminfo_semmns=5000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
wabby26Author Commented:
I'm trying this now, but you said:
"It should be at least the same size as the maximum number of Oracle processes."
So didn't you mean that 200 is OK?

wabby26Author Commented:
10x alot.
Well thats because you may have other stuff (other than Oracle including other OS requirement)

SEMMNS >= SUM of processes for ALLl Databases +  other system

I normally like to add my database needs to the already existing number + 10 to 15 %

Say if it was 1500 and I need a new database with 200 process then I would bump it up to something like 1750 or 1800, which allows for future expansion of larger processes.

You are right, 5000 may be more than what you need. But, it certainly is not going to hurt.  To arrive at the exact number for this you will have to have knowledge of every thing running on the machine with each appl's process requirements. Not an easy task!

You are certainly welcome to reduce it. But, you may have to go through some trail and error.
All Courses

From novice to tech pro — start learning today.