Oracle on linux 32 bits with 16 GIG Ram ORA-27102: out of memory

I need an sga size of 10g.
And a pga_aggregate_target of 3gig.
I have the following error: ORA-27102: out of memory When i start my database,

I cannot use Oracle 64 bits because oracle does not support "hsodbc" on 64 bits.

### Oracle version ###
10.2.0.3 32 bits

### /etc/sysctl.conf ###
kernel.shmall = 4103791
kernel.shmmax = 16106127360
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

### uname -a ###
Linux Mycomp.com 2.6.9-42.0.10.0.1.ELsmp #1 SMP Tue Feb 27 12:25:04 PST 2007 i686 i686 i386

### Red Hat Linux Release Information ###
cat /etc/redhat-release
Enterprise Linux Enterprise Linux AS release 4 (October Update 4)

### Umask Setting ###

0022
### Ulimit Settings ###

[oracle@2950 ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 274432

I found those metalink notes:
Note 260152.1 Summary About the Large SGA & Address Space on RH Linux
Note 264236.1 - Considerations on using "hugemem" Kernel vs SMP kernel
Note 317141.1 - How to Configure RHEL 4 32-bit for Very Large Memory with ramfs and HugePages


But im no sysadmin.

Anyone has specific info on how to enable oracle to use more than 1.7gig of ram on a 16 gig ram machine?

did you follow the instructions in the last note?

Follow This:

Procedure how to increase the SGA in LINUX AS/ES 3.


1. Shutdown the Database.

2. Add following kernel parameter in /boot/grub/grub.conf

Kernel /vmlinuz-2.6.9-34.ELsmp ro root=LABEL=/ rhgb quiet bigpages=6100 MB

Edit and Add following parameter in /etc/sysctl.conf

Kernel.shmmax = 4294967295 (not more then it)

3. Add following parameter in init.ora file:


Sample calculation for 2GB of db_block_buffers

(1024*1024*1024)*2/db_block_size (8192) = 262144


Instead of db_cache_size used following parameter

db_block_buffers=262144
use_indirect_data_buffers=true

4. Restart the Linux server.

5. Up the database and see SGA

SQL> show sga


Total System Global Area 3407418688 bytes
Fixed Size 451904 bytes
Variable Size 1258291200 bytes
Database Buffers 2147483648 bytes
Redo Buffers 1191936 bytes

That's with Linux ES 3, is it still applicable with ES4 and better than ramfs?

I think setting SHMMAX is wrong in your case.

Check this note may help you.