I am having a hard time increasing the amount of processes on my 8i DB. When I increase the size to about 50 in my init.ora file the DB cannot be restarted. It gives the error ORA-27146. Can someone please help he out with some information.
ORA-27146 means that the system is running out of semaphores. You can either decrease the "processes" parameter in the init.ora file, or increase the kernel parameters to accept more processes.
If you don't know how to configure the kernal you may need to speak to your Unix Administrator.
Based on the type of box you have sun, hp, aix you should search metaling for kernel parameters and have your unix admin rebuild the kernel after apply proper values to them. Reboot the box then try increasing the parms and it will work. Oracle needs to be allocated certain amount of system memory as well thats why you require kernel parms.
"High Salaries = Happiness = Project Success."
Click Here to Expand Forum to Full Width