ORA-27123 unable to attach shared memory segment

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. Received on Tue Mar 07 2000 - 00:00:00 CST