I am going to install Oracle10g database in Fujitsu 32bit server which has 16GB RAM . I am using RHEL 5 server with it . Since it is 32 bit server , so first . I have to install "kernel-PAE" to get the 16 GB Memory and reboot the server with that "kernel-PAE" .
Now ,I want to give the SGA Size 10GB .
so that I configure like following :
1) I increase the /dev/shm size = 10 GB
2) cat /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 10737418240 // HERE I SET THIS PARAMETER AS 10 GB
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
3) Also , I configure Hugememory Like following :
Booting the kernel-PAE , I get the hegupage size :
#cat /etc/meminfo | grep Huge
2048 K
Then I just follow the below rules :
# cat /proc/meminfo |grep Hugepagesize
Hugepagesize: 2048 kB
Follow the following steps to enable Oracle to start using Hugepage.
1. vi /etc/sysctl.conf file.
vm.nr_hugepages = 5220
3.Run the following command.
#sysctl -p
4. Modify /etc/security/limits.conf file to have following entry.
oracle soft memlock 20086560
oracle hard memlock 20086560
Then Reboot the machine.
5.Check the Hugepage Total and Hugepage Free using following command.
#cat /proc/meminfo | grep -i huge
This should return like following.
HugePages_Total: 5220
HugePages_Free: 5220
HugePages_Rsvd: 00
Hugepagesize: 2048 kB
Now when I install the database using DBCA , then I got the below error :
ORA-27102: out of memory
Since I am newbie to configure Oracle10g in huge memory supported server (16GB) .
I need a suggestion . Can I resolve this problem installing "kernel-hugemem" or not . And is the RHEL 5 supports >the "kernel-hugemem" ?
If I install “"kernel-hugemem" , then is it necessary to install “kernel-PAE” in RHEL 5 ?
And also tell me , what is the function of “Hugepagesize” . Is this hugepage increase the Hugepagesize: 2048 kB to >more ? But the above configuration , I cannot increase the Hugepage Size, it still remains 2048 KB ?