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

You need to reboot the unix server, after changing the /etc/system file.

It is tough to find clear and consistent info on semephores.

From my notes:
shmmax: the maximum size in bytes of a single shared memory segment. I set mine for the number of bytes in entire memory. Perhaps too big. But no problems so far.

In Oracle installations, it is the SEMMNS parameter that has given me trouble. From my notes, it is: - the number of semaphores in the system

This has to be higher than the number of all the processes in all the database init.ora files. Times 2. So, if you have 3 databases, each allowing 200 processes, that is 600 processes altogether. Times 2 = 1200. At least.

Yours at 300 may be too low.

When I had problems with semaphores, I got the error: ora-01034, and
ora-07429 - failed to get segment

Hope this helps.

In article <8seto6$c5n$1_at_news.netvision.net.il>,   "Lior" <lior_at_amicada.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 11 2000 - 16:16:18 CST