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?
wabby26Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mshaikhCommented:
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
                processes.

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.
0
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?
0
mshaikhCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

mshaikhCommented:
Those values are too low.
Try these:

set semsys: seminfo_semmns=5000
set semsys: seminfo_semmsl=275    
0
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.
0
mshaikhCommented:
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
0
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?

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

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

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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.