Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Processes and Semaphores on Solaris 5.9 with Oracle 8.1.7.4

Processes and Semaphores on Solaris 5.9 with Oracle 8.1.7.4

From: Kevin Lange <klange_at_ppoone.com>
Date: Wed, 10 Aug 2005 14:45:04 -0500
Message-ID: <ED1256BD4F253C44B1627B2D365A334F08766D56@ppoone1.ppoone.com>


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-l
Received on Wed Aug 10 2005 - 14:47:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US