Re: ORA-27123 unable to attach shared memory segment

j_books24x7_1_at_my-deja.com wrote:
>
> Running oracle 8.1.5.0.0 on Redhat 6.0 with kernel 2.2.12, I keep
> getting the error ORA-27123 unable to attach shared memory segment when
> trying to startup an instance with an SGA > 150 MB or so. I have
> modified the shmmax and shmall kernel parameters via the /proc/sys
> interface. The relevant output of ipcs -l is below:
>
> ------ Shared Memory Limits --------
> max number of segments = 128
> max seg size (kbytes) = 976562
> max total shared memory (kbytes) = 16777216
> min seg size (bytes) = 1
>
> This system has 2gb of physical memory and is doing nothing except
> oracle.
>
> I changed the shmmax and shmall parameters after the instance was
> created, was their something I needed to do to inform Oracle of the
> changes?
>
> Anything else I might be overlooking?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

SHMMAX sets the maximum size of an individual segment SHMMIN sets the minimum size of an individual segment SHMMNI sets the maximum number of segments systemwide SHMSEG sets the maximum number of segments per process

So, apparently your SHMMNI is good but your SHMMAX is too small. You'll need to take that up to 157300 at least - that should give you a large enough size. Received on Thu Mar 09 2000 - 00:00:00 CST