josh for u if uanswer me....

[fordikon]

My database is running on Solaris, -Oracle8i.

often it gives me error "maximum process exceeds", i tried increasing the processes in "init.ora" but after that i am unable to start the Database, i think some OS kernel parameters should be set, could anyone tell me how much the kernel parameter to set? and will it give any problem to the OS when i change the kernel.

bye

[hrishy]

refer your oracle documentation guide for your platform nad version it is usually mentioned in the pre-installation tasks.as i dont ahve a solaris specific docs i am unable to paste the kernel parameters here.

[pando]

well you have to increase

semaphores in system (SEMMNS)

[fordikon]

dear replies,

i tried increasing the SEMNS, and later i could able to increase the process in init from 50 to 55 only, how much i have to increase the semaphore parameters to accomadate PROCESS=100.


Can i use MTS, how to doooooo it.

thanks

[pando]

we have SEMNS 600 and we have process=300 but our machine only has Oracle installed

MTS cannot be explained in paragraphs, you better check the oracle docs

[fordikon]

till how much max value the SEMNS can be set and what r all the adv and disdvantages of setting more value.

i want to have PROCESS=200, then how much SEMNS i have to set.

[pando]

i cant answer that because I am not unix admin, i can only tell you we have set to 2500 i some servers and there werent any problems

you want 200 processes, cant you calculate roughly with my numbers....?

[fordikon]

Thanx,

[sambavan]

You can have a max of 32767 semaphores. You can check how much is in use by issuing this command

ipcs -sb|grep -v grep | grep oracle


This would tell the semaphores held by evey instance on your system.


The simple calculation would be that of

((SUM( #process per instance)) * 2) + (10 * #instances)


Don't try to go over board, because as pando suggested, it would cause semaphore problem.

For more details on ipcs refer the man pages.

Good luck,
Sam