From: argosy22@my-deja.com Newsgroups: comp.databases.oracle.server,comp.unix.solaris Subject: Re: how do I enable the Semphore - for oracle installation ? Date: Sat, 11 Nov 2000 22:16:18 GMT Organization: Deja.com - Before you buy. Lines: 62 Message-ID: <8ukgff$l7o$1@nnrp1.deja.com> References: <8seto6$c5n$1@news.netvision.net.il> NNTP-Posting-Host: 4.22.195.16 X-Article-Creation-Date: Sat Nov 11 22:16:18 2000 GMT X-Http-User-Agent: Mozilla/4.7 [en] (WinNT; I) X-Http-Proxy: 1.0 x67.deja.com:80 (Squid/1.1.22) for client 4.22.195.16 X-MyDeja-Info: XMYDJUIDargosy22 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@news.netvision.net.il>, "Lior" 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.