Processes and Semaphores on Solaris 5.9 with Oracle 8.1.7.4
- From: Kevin Lange <klange@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Aug 2005 14:45:04 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
