Out of Memory Error on Linux Server

[pareshjavkar]

Hi,

I have a Server:

O.S: Linux RHEL AS 3.0 Update 5 Taroon
RAM: 16 GB
SGA: 2.8 GB
Oracle: 9.2.0.1.0

My Server gives me Out of Process Memory Error at times.

I am using Normal Kernel for Booting and not Huge Mem Kernel.

Please advise, if booting from HugeMem Kernel may solve the Problem?

[abhaysk]

use automatic pga allocation

[pareshjavkar]

Hi,

What does Automatic pga allocation exactly mean, is it oracle 9i feature or oracle 10g

[KenEwald]

Post the results of ulimit -a and let's take it from there...

[pareshjavkar]

Post the results of ulimit -a and let's take it from there...

Dear Ken,

ulimit -a

core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited

[pareshjavkar]

Any Updates from anybody ?

[pando]

you should use SMP or Huge Mem Kernel if you have 16GB Memory

[pareshjavkar]

Hi,

Does it require, the Server to be booted with Huge Mem Kernel prior to oracle software installation
OR
is it Ok, if i do boot the Server now after oracle software installation, the latter i have tried and failed to resolve the problem.

[pando]

first of all show us the EXACT error message

[pareshjavkar]

Hi,

When i successfully booted from Huge Mem Kernel and tried starting my database:

It gave me an error:

Unable to attach shared memory segment.

We tried to lower the SGA_max_size and tried again, but with same error.

Please advise