Xref: alice comp.databases.oracle.server:58243 Path: alice!news-feed.fnsi.net!cyclone.i1.net!newsfeed.enteract.com!news.maxwell.syr.edu!newsfeed.cwix.com!24.93.67.47!cyclone.southeast.rr.com!news.rr.com!news-southeast.rr.com!news-out.cwix.com!news.cwix.com!not-for-mail From: "Gocha Mchedlishvili" Newsgroups: comp.databases.oracle.server References: <7n1ndq$pdo$1@nnrp1.deja.com> <7n1rf9$qqn$1@nnrp1.deja.com> <7n1v9k$sh9$1@nnrp1.deja.com> Subject: Re: unable to attach sga Lines: 48 X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Message-ID: Date: Wed, 21 Jul 1999 02:15:37 GMT X-Complaints-To: news@cw.net X-Trace: news.cwix.com 932523337 166.62.199.47 (Tue, 20 Jul 1999 22:15:37 EDT) NNTP-Posting-Date: Tue, 20 Jul 1999 22:15:37 EDT Hi, I might be wrong because I haven't played with Solaris kernel settings for a long while, but I think that SGA must fit in 1 continious segment, try to reduce shminfo_shmseg setting. Gocha rpereira@my-deja.com wrote in message <7n1v9k$sh9$1@nnrp1.deja.com>... >In article <7n1rf9$qqn$1@nnrp1.deja.com>, > Tony Adolph wrote: >> Hello there, >> >> I could be wrong here because my Solaris is a bit rusty, but check the >> kernel settings for shared memory and semaphores i.e. shmmax, smhmin >> etc in /etc/system. >> > >> > ORA-07307: sms1sg: shmat error, unable to attach sga. >> > SVR4 Error: 22: Invalid argument >> > >> >> hope thats helpful, >> >> Regards >> Tony >> >> Sent via Deja.com http://www.deja.com/ >> Share what you know. Learn what you don't. >> > >Hello, >the kernel settings for shared memory are: > >set semsys:seminfo_semmni=70 >set semsys:seminfo_semmns=200 >set semsys:seminfo_semmsl=100 >set shmsys:shminfo_shmmax=587202560 >set shmsys:shminfo_shmmni=100 >set shmsys:shminfo_shmseg=10 >set shmsys:shminfo_shmmin=1 > >It works if I set the shared_pool = 130000000, so I think the settings >are correct. > > >Sent via Deja.com http://www.deja.com/ >Share what you know. Learn what you don't.