Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Processes and Semaphores on Solaris 5.9 with Oracle 8.1.7.4
We are currently having an issue on one of our servers.
Its a Solaris 5.9 server running Oracle 8.1.7.4. There are 34 databases running on that server: 25 Production and 9 Standby.
Whenever we try to startup another database we get the Oracle message ORA-27146: post/wait initialization failed
Searching Metalink brought us to this:
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 setting in /etc/system file. The semamphore parameter is called "semmns".
Our current settings in the /etc/system file are :
set shmsys:shminfo_shmmax=1073741824 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmns=5000 set semsys:seminfo_semmni=700
My question to you all is this: The note in metalink was sketchy on what it would do to the system if we raised the SMMNS parameter up on the system. Does anyone have any experience in what affects raising the ceiling on Semaphores might have to this kind of system ?
Any response would be appreciated.
Kevin
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 10 2005 - 14:47:10 CDT
![]() |
![]() |