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

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!
========================================