-
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.
"What is past is PROLOGUE"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|