Re: how do I enable the Semphore - for oracle installation ?

While others have addressed the original questions, I did want to address the shminfo_shmmax parameter. The Oracle documentation incorrectly states that this parameter *has* to be set to 4 gig. Thinking about this for even a second it becomes immediately obvious that this cannot be true. Even Oracle support seems to think this is true. I called about a down production system and one of the questions they asked me was what the value of the settings in /etc/system were. I told them that I have shminfo_shmmax set to 440mb, rather than 4 gig.

Their response was that my database was then unsupported and they could not help me until I changed the value to 4gb!

My reponse to them was to have them justify to me why the value needs to be anything larger than just large enough to accomodate the SGA. They could not and they backed down, admitting that this value only needs to be large enough for the SGA.

--
Dave A


"Lior" <lior_at_amicada.com> wrote in message
news:8seto6$c5n$1_at_news.netvision.net.il...


> Hi

> I'm trying to install Oracle i8 at Solaris 2.8

>

> at /etc/system I added :

>

> shmsys:shminfo_shmmax=4294967295

> set shmsys:shminfo_shmin=1

> set shmsys:shminfo_shmmni=100

> set shmsys:shminfo_shmseg=10

> set semsys:seminfo_semmni=100

> set semsys:seminfo_semmsl=100

> set semsys:seminfo_semmns=300

> set semsys:seminfo_semopm=100

> set semsys:seminfo_semvmx=32767

>

> when I do ipcs

> it says that Semaphore Facility inactive

>

> how do I enable it ?

> thanks for any help

>

> Lior

>

>