thank you for your replay. Ok maybe the parameter will be set automatically but how I can prove this and why there is no SLES 11 and SLES 12 in the Environment list at
the top of the document ? With the change from 32 to 64 bit the calculation change because the max GB size >4GB memory per process. In 32 bit environment ~4 GB is the SHMMAX max.
But in 64 bit there is a very much higher. Oracle specialists recommend 4TB.
thank you for your replay. Ok maybe the parameter will be set automatically but how I can prove this and why there is no SLES 11 and SLES 12 in the Environment list at
the top of the document ? With the change from 32 to 64 bit the calculation change because the max GB size >4GB memory per process. In 32 bit environment ~4 GB is the SHMMAX max.
But in 64 bit there is a very much higher. Oracle specialists recommend 4TB.
Thank you ! Please help[/QUOTE]
Do you have orarun package installed, maybe that one is interfering, take a look inside /etc/sysconfig/oracle
The default SHMMAX for both SLES 11 and SLES 12 (x86_64 anyway) is
kernel.shmmax = 18446744073709551615 which I have confirmed now on two
out-of-the-box systems.
When I run ‘ipcs -l’ on my SLES 11 system it gives me this, among other
things:
max seg size (kbytes) = 18014398509481983
max total shared memory (kbytes) = 4611686018427386880
and SLES 12 returns the following:
max seg size (kbytes) = 18014398509481983
max total shared memory (kbytes) = 18014398509480960
The SHMMAX has always been this way, I think, as I have had to help
clients who wanted to change it (increase it) realize there was nothing to
change, specifically for Oracle reasons; it seems like other distributions
may have this value set to something else by default, but SLES has been
this way as long as I can remember (even in SLES 10 I believe, though I do
not have a system handy to check for verification).
–
Good luck.
If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below…
we delete all entries from /etc/sysctl.conf and disable them in the oracle init script /etc/sysconfig/oracle but after a reboot
we still dont get the right parameters
ipcs -l
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 3217741
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1
------ Semaphore Limits --------
max number of arrays = 256
max semaphores per array = 1250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767
------ Messages Limits --------
max queues system wide = 1915
max size of message (bytes) = 65536
default max size of queue (bytes) = 65536