Skip to contentSkip to conversation

SHM, Issue attaching Oracle >500MB shared mem

DISCUSSION Javan Dempsey 3 participants 3 messages Aug 5, 1999 – Aug 6, 1999 Memory management

lore
Share & tools
lore
#0 lore raw

Hello,
We're currently running a number of Linux based ia32 Oracle 8.0.5 DB Servers, and we seem to be running into a problem with attaching to > 500MB shared mem. I've increased SHMMAX and tweaked various other things in an attempt to fix the problem. Nothing seems to work, no matter what SHMMAX is set to, or anything else. SVRMGRL gives this error when trying to startup -

SVRMGR> startup open
ORA-27123: unable to attach to shared memory segment Linux Error: 22: Invalid argument
SVRMGR>

which seems to be an a shmat() error. Oracle is dumbfounded with the problem, and I'm not very familliar with the mm part of the kernel. The machine I am speaking of is a Quad Proc Dell PowerEdge 6350, with 4GB of physical mem, and 4GB of swap. Running a few of Kanoj's patches, along with his latest BIGMEM patch, although I've also tried stock kernels, and some of the -AC kernels. Actually, with 2.2.10-ac11, and the quick hack to support 2GB of mem, I couldnt use much more than 150MB of shared mem. The current configuration has gotten me the furthest, but still no dice. I've also tried this on various machines of different configs, i.e. some dual proc's (which shouldnt matter anyway I suppose), some with 1 or 2GB mem, and such. Anyone have any suggestions?

Thank you,
Javan Dempsey
Senior Unix Admin.
ICelebrate.Com Inc.
--
To unsubscribe, send a message with 'unsubscribe linux-mm' in the body to [email protected]. For more info on Linux MM,
see: http://humbolt.geo.uu.nl/Linux-MM/

#1 lore raw
Quoted 8 lines

Hello,
We're currently running a number of Linux based ia32 Oracle 8.0.5 DB Servers, and we seem to be running into a problem with attaching to > 500MB shared mem. I've increased SHMMAX and tweaked various other things in an attempt to fix the problem. Nothing seems to work, no matter what SHMMAX is set to, or anything else. SVRMGRL gives this error when trying to startup -

SVRMGR> startup open
ORA-27123: unable to attach to shared memory segment Linux Error: 22: Invalid argument
SVRMGR>

The best thing to do is probably put debug printks in sys_shmat() in ipc/shm.c and identify what is causing the problem.

Quoted 2 lines

which seems to be an a shmat() error. Oracle is dumbfounded with the problem, and I'm not very familliar with the mm part of the kernel. The machine I am speaking of is a Quad Proc Dell PowerEdge 6350, with 4GB of physical mem, and 4GB of swap. Running a few of Kanoj's patches, along with his latest BIGMEM patch, although I've also tried stock kernels, and some of the -AC kernels. Actually, with 2.2.10-ac11, and the quick hack to support 2GB of mem, I couldnt use much more than 150MB of shared mem. The current configuration has gotten me the furthest, but still no dice. I've also tried this on various machines of different configs, i.e. some dual proc's (which shouldnt matter anyway I suppose), some with 1 or 2GB mem, and such. Anyone have any suggestions?

Other than the 4Gb physmem patch, which other of my patches are you using?

As I said in private mail also browse

http://reality.sgi.com/kanoj_engr/tuning.html

Feel free to get in touch with me by private mail ... I am quite interested in being able to start off Oracle with some of my patches installed.

Kanoj

Quoted 2 lines

--
To unsubscribe, send a message with 'unsubscribe linux-mm' in the body to [email protected]. For more info on Linux MM,
see: http://humbolt.geo.uu.nl/Linux-MM/

#2 lore raw
In reply to Javan Dempsey
Quoted 6 lines · Javan Dempsey

We're currently running a number of Linux based ia32 Oracle 8.0.5 DB Servers, and we seem to be running into a problem with attaching to > 500MB shared mem. I've increased SHMMAX and tweaked various other things in an attempt to fix the problem. Nothing seems to work, no matter what SHMMAX is set to, or anything else. SVRMGRL gives this error when trying to startup -

Where did you change this value?

Your capitals would seem to indicate that you hacked on the kernel, but the new place to tune such parameters is /proc/sys/kernel/shmmax.

It would seem to default to 32Mb, which isn't nearly enough for a big Oracle setup.

# echo `expr 1024 \* 1024 \* 1024` > /proc/sys/kernel/shmmax

should allow you 1Gb of shared memory.

Matthew.

--
To unsubscribe, send a message with 'unsubscribe linux-mm' in the body to [email protected]. For more info on Linux MM,
see: http://humbolt.geo.uu.nl/Linux-MM/