Oracle requires one semaphone for each process defined in the init{SID}.ora
file. + four more for the brew!...
If processes are 4000 you'll need 4004 sempahore sets to start Oracle.
If there is not a really good reason why you have so many processes defined
you may like to consider downsizing it...

Not sure how many processes you have defined in your init{SID}.ora but maybe
worth checking...

KJB
----- Original Message -----
From: "cecile" <oracledba-ezmlmshield-x5083124.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, April 30, 2007 1:35 PM
Subject: RE: Semaphore settings


> Thanks Ed! 2000 isn't high enough for us (not even 4000 is high enough).
> I need to know if there is a reason why it couldn't be set to 32767 i.e.
> will the server take it if set to 32767? We're planning to add other
> databases on this server and 8192 may not be enough then.
>
> -----Original Message-----
> From: Edwards Ed
> [mailto:oracledba-ezmlmshield-x90496991.[Email address protected]
> Sent: 30 April 2007 13:24
> To: LazyDBA Discussion
> Subject: RE: Semaphore settings
>
> Well, well, wel,
> It's cecile! Hehe. How have you been? Below is what my /etc/system
> file looks like (Solaris 9).
>
>
> set noexec_user_stack=1
> set rlim_fd_max=65536
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmsl=1500
> set semsys:seminfo_semmns=2000
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semvmx=32767
>
>
>
> Ensure that your spellings are correct! Hehe.
>
>
>
>
>
> Please take a few minutes to provide feedback on the quality of service
> you received from our staff. The Department of Education values your
> feedback as a customer. Commissioner of Education Jeanine Blomberg is
> committed to continuously assessing and improving the level and quality
> of services provided to you.Simply use the link below. Thank you in
> advance for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
> From: cecile
> [mailto:oracledba-ezmlmshield-x20190260.[Email address protected]
> Sent: Monday, April 30, 2007 8:19 AM
> To: LazyDBA Discussion
> Subject: Semaphore settings
>
> Hi All,
>
> We're starting a new database but the server is complaining about the
> semaphore settings. The current setting for semmns is 4000. Are there
> any limits as to what this can be increased to? Can it be increased to
> 32767 (like semvmx)?
>
> Thanks.
> Cecile
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page