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

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Wed, 23 Feb 2000 12:12:27 +1100
Message-ID: <88vcmh$58r$1_at_perki.connect.com.au>

---

---

---

This is the output of ipcs -l and it shows that there is enough shared memory limits. Do we have to increase it further?

/u01/app/oracle/product/8.1.5>ipcs -l

• Shared Memory Limits -------- max number of segments = 128 max seg size (kbytes) = 32768 max total shared memory (kbytes) = 16777216 min seg size (bytes) = 1
• Semaphore Limits -------- max number of arrays = 128 max semaphores per array = 32 max semaphores system wide = 4096 max ops per semop call = 32 semaphore max value = 32767
• Messages: Limits -------- max queues system wide = 128 max size of message (bytes) = 4056 default max size of queue (bytes) = 16384

Thanks for the help.

Tom Zamani <tomz_at_redflex.com.au> wrote in message news:88sdpr$qvb$1_at_perki.connect.com.au...
> 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
>
>
>
Received on Wed Feb 23 2000 - 02:12:27 CET