[SunHELP] ORACLE & Solaris

[Ashish Shah]

This error is oracle memery related. Your DBA
should fix it.

Ashish.
Oracle DBA

--- Les <les at cdproc.com> wrote:
> This is the shared memory section of /etc/system
> from
> one of our larger database servers which had the
> same 
> problem several months ago.
> 
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set semsys:seminfo_semmns=1024
> set semsys:seminfo_semmni=256 
> 
> 
> Les
> ----- Original Message ----- 
> From: "Bashar" <big at kuwaitnet.net>
> To: <sunhelp at sunhelp.org>
> Sent: Friday, March 16, 2001 11:14 PM
> Subject: [SunHELP] ORACLE & Solaris
> 
> 
> > Regards,
> > on our E3500 with dual UltraSparc 400mhz and
> 1024Mb ram hosting a
> > large oracle database this error repeated twice in
> the last 4 weeks the
> > error from alter_BILLING.log:
> > 
> > ORA-04031: unable to allocate 4096 bytes of shared
> memory
> > 
> >  is this error oracle based error or system
> ram/memory error ? although
> > the dba said he alocated 600mb of memory on the
> database startup.
> > 
> > 
> > 
> >                     KuwaitNet Communications Inc.
> >         Bashar A AlAbdulhadi            UNIX & NET
> Administrator
> >         bashar at kuwaitnet.net           
> http://www.KuwaitNet.net
> >         Phone: (KW) +965-2647060        Fax: (KW)
> +965-5337060
> >         Phone: (US) +514-2417955        Fax: (US)
> +208-2755778
> >         ICQ UIN: 19907999               Pager:
> (KW) 9312471
> >         IRC: Big @ #Kuwaitnet           YaHoO ID:
> kuwaitnets
> >         Toll free (from USA & Canada only) 
> 1-888-KuwaitNET
> > 
> >            "Quality, Stability, 24 Hours Tech.
> Support"
> >                           "Think KuwaitNet"
> > 
> > _______________________________________________
> > SunHELP maillist  -  SunHELP at sunhelp.org
> > http://www.sunhelp.org/mailman/listinfo/sunhelp
> > 
> 
> _______________________________________________
> SunHELP maillist  -  SunHELP at sunhelp.org
> http://www.sunhelp.org/mailman/listinfo/sunhelp


=====
Ashish
Toronto, Canada
http://www.remotedba.ca

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/