Oracle Database Discussions

Hi All

I know this is a very basic question that I am asking and all the related fields that I needed to check and cross verify has already been performed and yet I could not resolve it hence need your guidance in resolution.

My OS version: RHEL 6 64 bit

Database: Oracle 10g Enterprise Edition Release 2

RAM: 8G

Swap 16G

When I am starting  the Db y issuing startup nomount I am getting the below error:

SQL> startup nomount

ORA-27125: unable to create shared memory segment

Linux-x86_64 Error: 1: Operation not permitted

/etc/sysctl.conf

----------------------

Only part of the same is pasted here which I changed for installing the software:

# Controls the maximum shared segment size, in bytes

#kernel.shmmax = 68719476736

kernel.shmmax = 4294967296 (Changed to this value after reading about the said parameter,since my RAM is only 8G and I wanted to give my SGA max to max 2G)

# Controls the maximum number of shared memory segments, in pages

#kernel.shmall = 4294967296

kernel.shmall = 1572864(Changed to this value after a calculation - i.e RAM setting for Oracle in GB*1024*1024*1024/kernel.shmmni = 4096)

net.ipv4.tcp_rmem = 4194304 4194304 4194304

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

net.ipv4.tcp_wmem = 262144 262144 262144

net.ipv4.tcp_rmem = 4194304 4194304 4194304

In /etc/security/limits.conf

-----------------------------------------

-----------------------------------------------------

SELINUX is Disabled

sga_target=2749904896

Please guide me to resolve the issue.

Thanks & Regards

Rijo.S.Roy