From MohanR@STARS-SMI.com Tue, 27 Feb 2001 15:06:22 -0800
From: "Mohan, Ross" <MohanR@STARS-SMI.com>
Date: Tue, 27 Feb 2001 15:06:22 -0800
Subject: RE: /etc/system parameters on Solaris 8
Message-ID: <F001.002BEFCF.20010227145535@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: MetaSlop -- More Screeching and Droning.



I'd 
set the shmmin to 1 and the shmmax to <machine memory 
size>.
<FONT face=Arial color=#0000ff 
size=2> 
if it 
were me, i'd probably have over-allocated something, so, i'd do an ipcs 
-a
for my 
"couple of databases" and make sure i had no more than two chunks 
of
shared 
memory allocated ( ignoring root stuff, of course). Not that 
breaking
the 
SGA into a few pieces is a crime against humanity, but....no positive 
need
to do 
it, either....
<FONT face=Arial color=#0000ff 
size=2> 
the 
unit shmmax is measured in is OS page sizes as i recall, but...just RTFM 

on 
<FONT face=Arial color=#0000ff 
size=2>/etc/system and it'll make it clearer than i could. 
<FONT face=Arial color=#0000ff 
size=2> 
<FONT face=Arial color=#0000ff 
size=2>hth
<FONT face=Arial color=#0000ff 
size=2> 
 

  <FONT face="Times New Roman" 
  size=2>-----Original Message-----From: alan.aschenbrenner@ihs.com 
  [mailto:alan.aschenbrenner@ihs.com]Sent: Tuesday, February 27, 2001 
  5:26 PMTo: Multiple recipients of list ORACLE-LSubject: 
  /etc/system parameters on Solaris 8
  <SPAN 
  class=718075221-27022001>Hey everyone,
  <SPAN 
  class=718075221-27022001> 
  <SPAN 
  class=718075221-27022001>    Recently I have setup a couple 
  8.1.6 databases on Solaris 8.  The databases appear to function normally, 
  but when I shutdown either of them I receive 
  the following message in a trace file:
  <SPAN 
  class=718075221-27022001> 
  skgm 
  warning: EINVAL creating segment of size 0000000004100000fix shm 
  parameters in /etc/system or equivalent
  <SPAN 
  class=718075221-27022001>(the message is repeated several 
  times except for the segment size being 
  different)
  <SPAN 
  class=718075221-27022001> 
  I 
  checked the /etc/system parameters and they are the same as some of my other 
  boxes (Solaris 6 machines running 4-6 databases each) and they seem to work 
  fine.  Memory shouldn't be a problem on this machine since it has 4 
  Gb of RAM with only 2 databases up and running.  Running 'top' 
  shows that plenty of memory is available also.  Here are the /etc/system 
  parameters for Oracle....
  <SPAN 
  class=718075221-27022001> 
  set 
  semsys:seminfo_semmni=750set semsys:seminfo_semmsl=600set 
  semsys:seminfo_semmns=1200set shmsys:shminfo_shmmax=67108864set 
  shmsys:shminfo_shmmni=1200set shmsys:shminfo_shmseg=180set 
  shmsys:shminfo_shmmin=30<FONT face=Arial color=#0000ff 
  size=2>
  Does 
  Solaris 8 require some of these parameters to be higher?  I tried looking 
  on MetaLink, but....well, you know that story.  Ask Ross Mohan for the 
  details on Metalink....
  <SPAN 
  class=718075221-27022001> 
  <SPAN 
  class=718075221-27022001>Thanks,
  <SPAN 
  class=718075221-27022001> 
  <SPAN 
  class=718075221-27022001>Alan
  <SPAN 
  class=718075221-27022001> 
  Alan 
  Aschenbrenner
  <SPAN 
  class=718075221-27022001>Oracle DBA
  IHS 
  Group
  <SPAN 
  class=718075221-27022001>(303)-858-6394
  <A 
  href="mailto:alan.aschenbrenner@ihs.com">alan.aschenbrenner@ihs.com
  <SPAN 
  class=718075221-27022001>