| number of process exceeds problem [message #56437] |
Mon, 31 March 2003 05:17  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
Hi.
I am running Oracle 7.0 under Unix environment.Sometime
i receives a message Maximum number or processes exceeds when i try to tune my process parameter in
init.ora files then it fails to start the database.Pl
help me.
tks.
Rajil
|
|
|
|
|
|
| Re: number of process exceeds problem [message #56443 is a reply to message #56437] |
Mon, 31 March 2003 14:32  |
JUAN
Messages: 23
Registered: November 2000
|
Junior Member |
|
|
hi,
you must increase the number of semaphores of your OS.
Take a look at this ( itīs for SCO UNIX but may be can help you)
SEMAPHORE ALLOCATION
Oracle just needs to allocate a number of semaphores equal to
the processes parameter in "init.ora".
SEMMSL= # of semaphores in a semaphore set
SEMMNI= the maximum # of semaphores sets in the system
SEMMNS= the number of semaphores in the system.
SEMOPM= max number of operations per semop call = 100
SEMVMX = semaphore max value = 32767
When an Oracle instance is started, all required semaphores will
be allocated.
Semaphores are allocated in sets.
Since each oracle process* requires a semaphore, the number that
is allocated is equal to the value of the init.ora
parameter PROCESSES. The total # of semaphores required is the
sum of all your instance's PROCESSES.
You can allocate all of your semaphores in one or more semaphore
sets.
If SEMMSL=PROCESSES, then only one semaphore set is required.
The maximum # of semaphores that can be allocated will be the
lesser of (SEMMSL*SEMMNI) or SEMMNS.
If SEMMSL is not equal to PROCESSES, be sure that the total # of
semaphores required (sum of PROCESSES) does not exceed the
maximum (SEMMSL*SEMMNI, SEMMNS).
For example, if SEMMSL=25 and SEMMNI=10, total # of semaphores
required (sum of PROCESSES) must not exceed 250 (10 semaphore sets * 25 semaphores/set).
Note: some Operating Systems have a maximum # of semaphore sets in the system.
If you have more than one instance and the values of PROCESSES
are different, you may want to make SEMMSL equal to the lowest
PROCESSES so that you don't allocate semaphores that will not be
used. Otherwise, this could prevent you from being able to
allocate all of your requirements.
For example:
Instance PROD has PROCESSES=100
Instance DEV has PROCESSES=50
If SEMMSL = 50, 3 semaphore sets will be allocated, 2 for PROD
and 1 for DEV.
If SEMMSL = 100, 2 semaphore sets will be allocated, 1 for PROD
and 1 for DEV.In this case, 100 semaphores will be allocated for
DEV when it will only use 50. These unused 50 semaphores cannot
be allocated for any other databases.
To see what semaphores have been allocated, use the Unix
command 'ipcs -b'.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
