Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Error 27123:Unable to attach to shared memory

Re: Oracle Error 27123:Unable to attach to shared memory

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 22 Feb 2000 15:47:09 GMT
Message-ID: <38B2AF7D.A418420B@edcmail.cr.usgs.gov>


I've never played with Oracle on Linux, but I can offer a tidbit that may shed some light. On Sun Solaris (and SGI Irix I think), there is a kernel parameter called SHMAX (or SHMMAX) which determines the max size of shareable memory. You might want to try there.

HTH,
Brian

Tom Zamani wrote:
>
> Could you please help me with this.
> WE are running Oracle 8i on linux (Red hat 6.0, 2.2.7-1.15 kernel), and we
> getting Oracle Error 27123:Unable to attach to shared memory Segment when we
> bumped up the DB_BLOCK_BUFFERS to a high value. We have played with the
> buffers and found out that the maximum SGA size it can go to is 140MB before
> Oracle gives this error. We have nearly 0.5 gig physical memory and would
> like to have a bigger SGA.
>
> Has anyone come across this problem?
>
> Thank you

--



Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my company!
Received on Tue Feb 22 2000 - 09:47:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US