PDA

View Full Version : Can't change kernel params for oracle xe



uzee
23rd July 2007, 08:56 AM
Hi All,

I have a VPS account for a dev application which uses java, tomcat with oracle xe backend. My task is to setup the server so that the app can be ported over and tested/demonstrated.

Its running Fedora Core 5. I have so far been able to install java and tomcat successfully. I also installed oracle xe without any errors but for some reason my oracle db does not start and gives me a memory error.

I followed all directions from the install guide and discussed this on orafaq.com and it seems like I need to change certain kernel params as required by oracle but I can't, I get a permission denied error even though I'm root.

Below is the /etc/sysctl.conf lines that I have inserted and then did a sysctl -p to reread the config but it doesn't seem to work.

#begin oracle specific parameters
kernel.shmall = 2097152
kernel.shmmax = 7956500000
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 = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
#end oracle specific paramters

[root@host]# sysctl -p /etc/sysctl.conf
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
error: "Operation not permitted" setting key "net.ipv4.tcp_syncookies"
kernel.shmall = 2097152
kernel.shmmax = 7956500000
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
error: "Operation not permitted" setting key "fs.file-max"
error: "Operation not permitted" setting key "net.ipv4.ip_local_port_range"
error: "Operation not permitted" setting key "net.core.rmem_default"
error: "Operation not permitted" setting key "net.core.rmem_max"
error: "Operation not permitted" setting key "net.core.wmem_default"
error: "Operation not permitted" setting key "net.core.wmem_max"
[root@host]#

[root@host]# echo 262144 > /proc/sys/net/core/rmem_default
-bash: echo: write error: Operation not permitted

I was able to set one parameter with the "w" switch but sysctl -a still shows old value:


[root@host]# sysctl -w kernel.shmmax=7956500000
kernel.shmmax = 7956500000

[root@host]# sysctl -p /etc/sysctl.conf
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
error: "Operation not permitted" setting key "net.ipv4.tcp_syncookies"
kernel.shmall = 2097152
kernel.shmmax = 7956500000
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
error: "Operation not permitted" setting key "fs.file-max"
error: "Operation not permitted" setting key "net.ipv4.ip_local_port_range"
error: "Operation not permitted" setting key "net.core.rmem_default"
error: "Operation not permitted" setting key "net.core.rmem_max"
error: "Operation not permitted" setting key "net.core.wmem_default"
error: "Operation not permitted" setting key "net.core.wmem_max"

[root@host]# sysctl -a|grep shm
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 3661532704 ................... (still shows old value)
error: "Operation not permitted" reading key "kernel.cap-bound"
[root@host]#


The original oracle error is also given for reference:

[root@host]# su - oracle
-bash-3.1$ id
uid=502(oracle) gid=502(dba) groups=502(dba)

-bash-3.1$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 21 21:16:24 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> connect
Enter user-name: sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Warning: You are no longer connected to ORACLE.
SQL> exit
-bash-3.1$
-bash-3.1$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 21 21:23:21 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup;
ORA-27102: out of memory
Linux Error: 28: No space left on device
SQL> exit

SYSTEM INFO:

[root@host]# uname -a
Linux host 2.6.9-023stab044.4-smp #1 SMP Thu May 24 17:23:29 MSD 2007 i686 i686 i386 GNU/Linux
[root@host]# rpm -qa|grep oracle
oracle-xe-univ-10.2.0.1-1.0

[root@host]# free -m
total used free shared buffers cached
Mem: 2022 1644 377 0 268 661
-/+ buffers/cache: 714 1307
Swap: 4094 0 4094

[root@host]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
vzfs 9437184 882209 8554975 10% /

[root@host]# echo $ORACLE_HOME
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

[root@host]# echo $ORACLE_SID
XE
[root@host]#

Sorry for the length of the post but I wanted to give all the information that may be relevant ....
Based on the discussions at orafaq, it seems like it may work after changing the kernel params, please help....

Thanks in advance
uzee

uzee
23rd July 2007, 11:37 PM
Anyone...????? Could someone please help me in the right direction if this is not the place to ask this...?
Thanks very much, I really need to fix this..
uzee

A.Serbinski
24th July 2007, 05:56 AM
If you have the option, use centos5 32bit. Very very similar OS, but oracle xe will work without giving you a headache.

rskokan
16th December 2009, 07:55 AM
If you have the option, use centos5 32bit. Very very similar OS, but oracle xe will work without giving you a headache.

I'm just running CentOS 5.4 and am also having the issues with changing net.core.* params. From browsing another forums the problem seems to be rather in the virtualization than the OS itself.